Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Excel functions in VBA
I wrote the following code in VBA. This worked fine.
Range("C30").Value = Application.Index(Range("A1:I18"), "13", "6") I compared this code to the one below which is similar in format. Am I correct in assuming in order to codify an Excel function in VBA all you have to do is Add the prefix "Application." to the function name followed by parenthesis and the internal variables? I assumed this when writing the following code that yielded an error. When I ran the code a dialog popped up stating "Object doesn't support this Property or Method". Range("C27").Value = Application.Address(Range("C26").Value, "4", "4") Perhaps the function "Address" was not recognized in VBA. Although the "Application." prefix worked in the first line of code, I thought one had to write "Application.WorksheetFunction." preceding the actual excel function in order to codify the function. Would someone please clarify? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple functions, conditional functions | Excel Worksheet Functions | |||
How to convert cell formula functions to code functions | Excel Discussion (Misc queries) | |||
efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) | |||
Conversion from Spreadsheet Toolkit functions (ESSV....) to EssBase API functions | Excel Programming | |||
excel functions and User defined functions | Excel Programming |