View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
George[_3_] George[_3_] is offline
external usenet poster
 
Posts: 14
Default 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