Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
Any help would be much appreciated. I have 2 For loop that colors specific cells I would like to save the range of colored cells each time through loop until end. then I cut range of cell and paste in different location. This is code I have so far but I cannot get my hand on that range of cells. Dim rng As Range For i = 100 To 1000 For j = 50 to 150 Cells(i, j).Interior.ColorIndex = 40 rng = ?? 'here I would like to save specific cells in a range to use later End If Next rng.Select Selection.Cut Destination:=Range("A1") |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Range Loop | Excel Programming | |||
Add a Range to an existing Range in a loop? | Excel Programming | |||
Loop through a range | Excel Programming | |||
loop in range | Excel Programming | |||
Loop in a Range | Excel Programming |