VBA Range Selection

[lpsd]

Hello:

I'd like to be able to select a range (which varies in height and length) using VBA. Starting at say cell E5 and going down to the end but then going over to the right for only three cells, not to the end right.

using the recorder and holding down the shift key produces the range but the code hard codes the cell references.

thanks,
lowell

 

[njimack]

One way...

Dim End_Row as Long

End_Row = Range("E5").End(xlDown).Row

Range("E5:H" & End_Row).Select

 

[lpsd]

thanks. that does seem to work. i'll play with it. thanks again