Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
selecting more than one cell
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
selecting more than one cell
Separate the ranges with commas
Range("A1,B2:B4,C3").Select I don't know if there's a limit on the number of ranges you can specify in this manner. "RobcPettit" wrote: 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
selecting more than one cell
Dim myRng as range
dim i as long set myrng = nothing for i = 3 to 33 if activesheet.cells(i,"D").value = true then if myrng is nothing then set myrng = activesheet.cells(i,"D") else set myrng = union(myrng, activesheet.cells(i,"D")) end if end if next i if myrng is nothing then msgbox "Nothing to select!" else myrng.select end if RobcPettit wrote: 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 -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
selecting more than one cell
Thanks all, Dave's worked perfect. Thanks again.
Regards Robert |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 single cell selecting muliple cell | Excel Worksheet Functions | |||
Selecting a cell entry based on cell validation selection | Excel Worksheet Functions | |||
Transfer cell values to another cell by selecting button. | Excel Worksheet Functions | |||
enter text in cell just by selecting cell | Excel Programming | |||
Selecting 10 charcters on one cell and pasting to another cell | Excel Programming |