Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am new to Macros in Excel can someone please help. I am trying to turn this
macro into a loop that will go from column c to column r. Now I have the same Step copyed over and over again. For i = 2 To 200 Step 1 e = "c" & i x = Range(e).Interior.Color Select Case x Case 12632256 Range(e).Value = "" With Range(e).Interior .Pattern = xlNone End With End Select Next For i = 2 To 200 Step 1 e = "d" & i x = Range(e).Interior.Color Select Case x Case 12632256 Range(e).Value = "" With Range(e).Interior .Pattern = xlNone End With |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
loop thru column and highlight the rows | Excel Discussion (Misc queries) | |||
Loop help | Excel Discussion (Misc queries) | |||
vba loop | Excel Discussion (Misc queries) | |||
Do Loop | Excel Discussion (Misc queries) | |||
Loop | Excel Discussion (Misc queries) |