*Kita sedang bicara tentang Makro Excel 4*
Angka 6 berarti ingin menampilkan *FORMULA dlm cell yg dirujuk*
argument GET CELL ada 60 lebih, (pernah ditayangkan di milis ini lengkap)
ini siti pilihkan sebaign yg penting penting
*Proposed Name*
*Arg #*
*What =GET.CELL(Arg #,INDIRECT("RC[-1]",)) will return*
AbsReference
1
Absolute style reference like [Book1.xls]Sheet1!$A$1
ShowValue
5
Cell value
ShowFormula
6
Cell formula
NumFormat
7
Number format of cell
IsLocked
14
True if cell is locked
FormulaHidden
15
True if cell formula is hidden
ShowWidth
16
Cell width. If array-entered into two cells of a row, second value is true
if width is standard
ShowHeight
17
Cell height
WorkbookName
32
Workbook name like [Book1.xls]Sheet1 or Book1.xls if workbook and single
sheet have identical names
ShowFormulaWOT
41
Cell formula without translation into language of workspace
HasNote
46
True if cell has a text note
HasFormula
48
True if cell contains a formula
IsArray
49
True if cell is part of an array formula
IsStringConst
52
Text alignment char ' if cell is a string constant, empty string if not
AsText
53
Cell displayed as text with numbers formatted and symbols included
WorksheetName
62
Worksheet name like [Book1.xls]Sheet1
WorkbookName
66
Workbook name like Book1.xls
2011/6/16 Septi Yunita <[email protected]>
>
>
> Dear belajar excel,
>
> Mau Tanya nech.. saya sedang baca-baca buku excel, ada bab tentang mengubah
> formula ke teks
>
>
>
> Missal :
>
> A1=1
>
> A2=2
>
> A3=3
>
> Di A4=sum(A1:A3)
>
>
>
> Untuk *mengubah formula di A4 menjadi teks* dapat menggunakan define name
> yaitu :
>
> 1.insert>nama>define
>
> 2.isi name
>
> 3.isi refers to dengan :
>
> * =GET.CELL(6,B4)*
>
> Pertanyaan saya angka* 6* diatas berarti apa ya??
>
>
>
> Trims atas bantuan dan penjelasannya
>
