Posted to microsoft.public.excel.misc

George[_3_] George[_3_] is offline

external usenet poster

Posts: 14

VBA:: determine if UDF exists?

In a workbook w/ multiple sheets, w/ a loop thus ...

dim mySheet as worksheet
For Each mySheet In ActiveWorkbook.Sheets
mySheet.Activate
Worksheets(mySheet.Name).myUDF
Next mySheet

Can I test whether 'myUDF' exists in each mySheet?

I can solve my problem using 'On Error GoTo ...', or by creating a stub
in each sheet; I'm just wondering if there's a more direct way to get
there.

Thanks,
George

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Determine if a File Exists	Connie	Excel Discussion (Misc queries)	1	November 8th 06 09:11 AM
File Exists	Mike McLellan	Excel Discussion (Misc queries)	2	May 4th 06 09:20 AM
Need help with a function I'm not sure exists	Cervantes	Excel Worksheet Functions	7	August 16th 05 06:38 AM
Determine if Value in column A exists in Column B	TJKarakowski	Excel Discussion (Misc queries)	3	July 19th 05 06:27 PM
Sheet name already exists	eddie_zoom	Excel Discussion (Misc queries)	1	March 11th 05 02:53 PM

All times are GMT +1. The time now is 02:41 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us