LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
GC GC is offline
external usenet poster
 
Posts: 18
Default Not sure what the subject is

Hi,

I have 4 worksheets named System 1,......System 4.

The following code example has to be repeated 4 times to cover all sheets.
If Worksheets("System 1").Cells(RC, 11).Value = "" Then blah blah blah
If Worksheets("System 2").Cells(RC, 11).Value = "" Then blah blah blah
and so on

I would like to create a variable name called SheetNum and replace the
actual number 1,2,3 and 4 with this variable. I will but this in a loop
incrementing SheetNum each pass and the single line of code will cover my 4
sheets.

This is what i have tried but will not compile.
If Worksheets("System " + SheetNum + ")".Cells(RC, 11).Value = "" Then blah
blah blah

Thanks in advance for any help you can give me,
Cheers!


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
No Subject Charts and Charting in Excel 0 June 5th 05 12:00 AM
No Subject Excel Discussion (Misc queries) 0 April 24th 05 12:00 AM
No Subject Excel Discussion (Misc queries) 0 April 23rd 05 12:00 AM
Not sure what to name this subject MARTY Excel Programming 4 July 4th 04 03:49 PM
No Subject No Name Excel Programming 0 January 1st 70 01:00 AM


All times are GMT +1. The time now is 07:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"