Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
UserDefined Functions
Is there a quick way in VBA to tell if a function used in
a cell formula is a userdefined function? That is, I know I can load the Excel Functions into an array and then do a match on the function found in the cell against the array and check to see if it is in the array. If its not found (iserror =true) its userdefined. But this means I have to actually find funtions in formulas to do this? Is there an easier way to spot userdefined functions in formulas? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
number of userdefined formats | Setting up and Configuration of Excel | |||
userdefined trendline | Excel Programming | |||
How to use multiple sheets with range in userdefined function. | Excel Programming | |||
Passing Parameters to Userdefined Functions | Excel Programming | |||
UserDefined Function that opens another w/book | Excel Programming |