View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nik[_4_] Nik[_4_] is offline
external usenet poster
 
Posts: 3
Default Execute class method on all worksheets?

Hi,

I have an class instance on all my worksheets, is there some way I
can dynamically execute a method on these objects? Something like

for each worksheet in worksheets
worksheet.myObject.myMethod
next worksheet

?