Posted to microsoft.public.excel.programming

AucklandAssault AucklandAssault is offline

external usenet poster

Posts: 6

CodeName Referencing Help

I want to exclude 4 worksheets from my macro. Is there are better way to
write the below?

If Project.CodeName < "Sheet01" And Project.CodeName < "Sheet02" And
Project.CodeName < "Sheet03" And Project.CodeName < "Sheet04"

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 help	Gary Keramidas	Excel Programming	14	October 31st 05 12:32 AM
Referencing worksheet CODENAME in a chart object.	Bing	Excel Discussion (Misc queries)	1	February 15th 05 01:01 AM
Referencing worksheet CODENAME in a chart object.	Bing	Excel Programming	2	February 14th 05 07:08 PM
Worksheet codename	Andy	Excel Programming	4	December 2nd 03 04:12 PM

All times are GMT +1. The time now is 09:29 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us