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

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

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