selecting more than one cell
First, we need to know what is actually in the cells you are trying to
match... is it Excel's TRUE or is it really the text "True"? If text, is the
text always an upper case T followed by lower case letters?
Rick
"RobcPettit" wrote in message
...
Hi, Im trying to select more than one cell depending on a value in
another cell.
For i = 3 To 33
If Range("d" & i) = "True" Then
Range("as" & i).Select
End If
Next i
there could be several cells, so I want to select them all, or they
may alternate. Simular to using the control button when selecting
various cells. 99% of the time they will be grouped together, so Im
guessing I could select the first cell the offset to select the next.
I dont know though how to select more than one cell this way.
Regards Robert
|