Posted to microsoft.public.excel.programming

Nik[_4_]

external usenet poster

Posts: 3

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

?

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
Add method of Workbooks class failed	Bill Baker[_2_]	Excel Programming	0	November 6th 06 04:33 PM
Copy method of worksheet class failed - loop copying worksheets	lif[_12_]	Excel Programming	0	July 31st 06 10:02 PM
Should Method Belong to the Class?	Trip[_3_]	Excel Programming	1	September 20th 05 09:29 PM
Specify which method is default in custom class	Bing	Excel Programming	1	December 23rd 04 10:33 PM
Calling from C#.Net App Office._CommandBarButton.Execute() method in Excel 2003 throws a COMException	Jacek	Excel Programming	1	December 21st 03 03:48 PM

All times are GMT +1. The time now is 03:44 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us