Posted to microsoft.public.excel.programming

ryguy7272

external usenet poster

Posts: 2,836

If Sheet Name, No Action

Is there an easier way to do this:
If (sh.Name) < "SH1 - Ryan" Then
If (sh.Name) < "SH1 - Jimmy" Then
If (sh.Name) < "SH1 - Tim" Then
If (sh.Name) < "SH1 - Todd" Then
If (sh.Name) < "SH1 - Frank" Then
If (sh.Name) < "SH1 - Susie" Then

Something like this:
If (sh.Name) < "SH1 - *" Then

(but this does not work€¦)

Regards,
Ryan---

--
RyGuy

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
Excell copy action pauses for 15 second for the smallest action	Meekal	Excel Discussion (Misc queries)	1	January 28th 10 04:30 PM
Copy Sheet action very slow	RobN[_3_]	Excel Discussion (Misc queries)	0	June 27th 07 03:32 AM
Action on sheet Selection	jpizzle[_8_]	Excel Programming	4	June 13th 05 05:33 PM
Action on sheet Selection	Piranha[_9_]	Excel Programming	0	June 7th 05 08:59 AM
How to action on Open Sheet	Jan Nademlejnsky	Excel Programming	1	December 8th 04 06:03 AM

All times are GMT +1. The time now is 01:54 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us