If Worksheet Name Does not equal more than one.

**ANDREWA** · 10-01-2012, 07:40 AM

Need help with the following simple line of code. It runs the macro perfectly for all sheets other than the one stated in the following line:

Please Login or Register  to view this content.

But I need it to exclude more than on sheet, e.g:

Please Login or Register  to view this content.

but cant get it to work, all help much appreciated.

Thanks

**buran** · 10-01-2012, 07:50 AM

Hi,
you could use Select Case statement instead of If statement. Like this

Please Login or Register  to view this content.

Assuming MyWorksheetName is variable that holds the sheet name you want to check. There may be other solutions, but that's the first that comes to my mind based on information provided.

If Worksheet Name Does not equal more than one.

LinkBack

Thread Tools

Rate This Thread

Display

If Worksheet Name Does not equal more than one.

Re: If Worksheet Name Does not equal more than one.

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions