Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
application worksheetfunctions fail
Hi all,
I am wondering why some orksheetfunctions can be addressed and others can't. If you look in the autolist of application.worksheetfunctions there is no suggestion for Find. But, when you address it in a module as mystring=application.worksheetfunction.find(all the proper arguments) it will run as expected. However, with the worksheetfunctions like value or date, when run in a udf you will always end up with #value!. What's the logic? Any help is greatly appreciated. Greets Sybolt |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Paste special function in macros fail if we disable application cellDrap Drop | Excel Programming | |||
Application.WorksheetFunctions | Excel Programming | |||
WorksheetFunctions | Excel Programming | |||
Why does Outlook.Application.GetNamespace("MAPI") Fail? | Excel Programming | |||
No VBA help for Worksheetfunctions available | Excel Worksheet Functions |