View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein \(MVP - VB\)[_2493_] Rick Rothstein \(MVP - VB\)[_2493_] is offline
external usenet poster
 
Posts: 1
Default 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