Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range Question
I have the following statement
Rows(Target.Row + 3 & ":" & Target.Row + 4).Select And what I really want to do is select the cells that are in column Target.column and rows Target.row to target.row+1. What would I need to change? Hopefully this will go through. I've had a lot of difficulty posting questions of late. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range Question
Selections are rarely desired or needed
Cells(Target.Row, Target.Column).Resize(2, 1).Select End Sub -- Don Guillett SalesAid Software "Barb Reinhardt" wrote in message ... I have the following statement Rows(Target.Row + 3 & ":" & Target.Row + 4).Select And what I really want to do is select the cells that are in column Target.column and rows Target.row to target.row+1. What would I need to change? Hopefully this will go through. I've had a lot of difficulty posting questions of late. Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range Question
Or just:
Target.resize(2,1).select Barb Reinhardt wrote: I have the following statement Rows(Target.Row + 3 & ":" & Target.Row + 4).Select And what I really want to do is select the cells that are in column Target.column and rows Target.row to target.row+1. What would I need to change? Hopefully this will go through. I've had a lot of difficulty posting questions of late. Thanks -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Range question w/VB | Excel Programming | |||
Range question | Excel Programming | |||
Range Question / error 1004: method Range of object Worksheet has failed | Excel Programming | |||
Range question | Excel Programming | |||
Range.Formula and Range question using Excel Automation | Excel Programming |