Posted to microsoft.public.excel.programming

Nigel[_2_] Nigel[_2_] is offline

external usenet poster

Posts: 735

Codename passing

Hi All
I have the codenames for various worksheets stored as strings in another
worksheet. How can I assign each sheet to an object?

e.g. If I have the string "myCodeName" which is the codename for one of the
worksheets, and want to assign it to a worksheet object

Dim wSh as Worksheet
Set wSh = ??

TIA
--

Regards,
Nigel

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
string to codename	rk0909	Excel Discussion (Misc queries)	4	September 25th 08 10:57 PM
CodeName Referencing Help	AucklandAssault	Excel Programming	3	February 6th 07 04:09 AM
Codename conflict	Jim Rech	Excel Programming	0	January 22nd 07 04:20 PM
codename help	Gary Keramidas	Excel Programming	14	October 31st 05 12:32 AM
Worksheet codename	Andy	Excel Programming	4	December 2nd 03 04:12 PM

All times are GMT +1. The time now is 10:53 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us