[SOLVED]Is there a way to do this , Just open the multiple sheets and go to the same cell , highlight it then go to the next sheet. The sheet names will change monthly.
Do I have to actually specify the sheet name?
[SOLVED]Is there a way to do this , Just open the multiple sheets and go to the same cell , highlight it then go to the next sheet. The sheet names will change monthly.
Do I have to actually specify the sheet name?
Last edited by DanielRay; 03-14-2013 at 01:55 PM.
Try this on a copy of your workbook.
Please Login or Register to view this content.
First thanks for the Quick response. Second if i wanted to add multiple cells do i just copy this as a new line "Sheets(i).Range("D15").Interior.Color = vbRed" or is there a separator like a comma,
to put multiple cells?
Last edited by DanielRay; 03-14-2013 at 12:29 PM. Reason: more info
Sub Maybe()
Dim i As Single
For i = 1 To ActiveWorkbook.Sheets.Count
Sheets(i).Range("D5, D7, D9").Interior.Color = vbRed
Next i
End Sub
SOLVED Solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks