YellowLabPro
03-17-2007, 04:04 AM
This procedure works fine w/ my existing worksheet. However I now would like to change the range of the looping to a variable to handle when I add or delete rows.
I have an idea of how to find the last row, but this worksheet has a summary area below the worksheet. It is separated by one blank row, if I use this to countdown rather than xlUp, I think this will work.
The other specific is the last row in the worksheet 133 needs to be left intact. So when we find the lastrow we need to add the -1.
I need some assistance in altering the two lines:
For x = 16 To 132 Step 2
Cells(x, "K").Interior.ColorIndex = 35
Next x
For x = 17 To 131 Step 2
Cells(x, "K").Interior.ColorIndex = 37
Next x
Thanks--
YLP
I have an idea of how to find the last row, but this worksheet has a summary area below the worksheet. It is separated by one blank row, if I use this to countdown rather than xlUp, I think this will work.
The other specific is the last row in the worksheet 133 needs to be left intact. So when we find the lastrow we need to add the -1.
I need some assistance in altering the two lines:
For x = 16 To 132 Step 2
Cells(x, "K").Interior.ColorIndex = 35
Next x
For x = 17 To 131 Step 2
Cells(x, "K").Interior.ColorIndex = 37
Next x
Thanks--
YLP