Powered by Telkomsel BlackBerry® -----Original Message----- From: "summonery" <[email protected]> Sender: [email protected] Date: Wed, 23 May 2012 13:12:58 To: <[email protected]> Reply-To: [email protected] Subject: [belajar-excel] Re: Macro Tidak Jalan
saya tambahkan link & info-nya ya mbak Rara, http://support.microsoft.com/kb/107564 <http://support.microsoft.com/kb/107564> (Not All Worksheet Functions Supported as Application)In Microsoft Visual Basic for Applications, not all Microsoft Excel worksheet functions are supported as methods of the Application object. If you attempt to use one of these worksheet functions with the Application object, you will receive the following error message: Run-Time Error '438': Object doesn't support this property or methodThe following table contains worksheet functions that are not available as methods of the Application object. The Visual Basic Equivalent column lists functions you can use that will produce the same (or similar) results that the functions return. Microsoft Excel Visual Basic worksheet function equivalent ---------------------------------- --------------------------------- ABS() Abs function ATAN() Atn function CHAR() CHR function CODE() ASC function COS() Cos function DATE() DATESERIAL function ERROR.TYPE() ERR function EXACT() STRCOMP function EXP() Exp functin INDIRECT() No direct equivalent - use Range, Cells, Offset, or any other way of referencing cells. INFO() No direct equivalent - use the following: CURDIR function, the following Application properties (MEMORYTOTAL, MEMORYUSED, MEMORYFREE, VERSION, OPERATINGSYSTEM, CALCULATION, COUNT) ISBLANK() ISEMPTY function ISREF() TYPENAME function LEN() LEN function LOWER() LCASE function N() No equivalent (none needed) NA() No equivalent - use ActiveCell.Value = "#N/A" RAND() RND function RANDOMIZE() Randomize function SIN() Sin function SIGN() Sgn function SQR() Sqr function SQRT() Sqr function T() No equivalant (none needed) TAN() Tan function TODAY() DATE function TRUNC() FIX function TYPE() TYPENAME function UPPER() UCASE function VALUE() VAL function NOTE: The Microsoft Excel worksheet function and the Visual Basic equivalent operator or function are not always calculated the same way and may give different results, even when they have the same name. -------+1 offline excel help, search: "List of Worksheet Functions Available to Visual Basic" >semoga bermanfaat --- In [email protected], Rara Wilis <ra2wilis@...> wrote: > > Dear pak Hendrik > > (0) > ini salah satu links nya > http://msdn.microsoft.com/en-us/library/aa221655(v=office.11).aspx > > (1) > di module VBA, kita juga dapat mengetikkan *WorksheetFunction.* > (jangan lupa TITIK-nya), dan di sebelah kanannya akan muncul > AutoListMembers -nya > (jika VBE pak hendrik: Option utnuk itu dihidupkan) > > (2) > Ada juga: di *OffLine_Help*, Tekan tombol F1; cari topik "WorksheetFunction > Object Members > [image: Inline image 1] > > > (3) > masih ada lagi dari VBE windows; tekan tombol fungsi F2, akan > menampakkan *Objects > Browser* > dari situ kita search" WORKSHEETFUNCTION, dan kita pun dapat melihat Member > List - nya > > memberlist dari wirksheetfunction tentunya fungsi² ex Worksheet yg dapat > diberlakukan di VBA. > CMIIW > ~rara > > > > *2012/5/23 hendrik karnadi hendrikkarnadi@... > * > > > > * * > > *Boleh dishare Mbak, Fungsi Worksheet apa saja yang bisa dipinjam VBA ?* > > *Karena kadang kita lupa menuliskan "WorksheetFunction"nya.* > > * > > * > > *Salam,* > > *Hendrik Karnadi* > > > > ------------------------------ > > *From:* Rara Wilis ra2wilis@... > > *To:* [email protected] > > *Sent:* Wednesday, 23 May 2012, 12:27 > > *Subject:* Re: [belajar-excel] Macro Tidak Jalan > > > > memang sebenarnyalah bahwa di VBA *tidak ada fungsi *bernama* Istext* > > yang ada *IsNumeric* bisa digunakan di VBA sebagai Istext-nya worksheet > > dengan cara > > *Not Isnumeric(data)* > > > > jika anda ingin tetap ber-*Istext*-ria, bilanglah dulu kepada worksheet > > bahwa anda pinjam f > > ungsi tsb: *WorksheetFunction.Istext(Data)* > > > > catatan gak penting: > > tidak semua fungsi milik worksheet bisa "dipinjam" di VBA (ada daftarnya) > > > > >
