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
|