Dynamic Range
 

Guys i have a dynamic range that to find the last Cell with data in i use


Range("A3").End(xlDown).Offset(-1, 0).Select

i now need to select across to column L and up to Row 3 i have used

ActiveCell.Resize(1, 12).Select to select to column L but how do i
select up to row 3

Thanks in advance

Arnie

Dynamic Range
 

If I understand you correctly this should work.

Range(ActiveCell,Cells(3,12)).Select

Dynamic Range
 

Range takes 1 or 2 arguments. If you supply 2 arguments you get the
rectangular range bounded by the 2 ranges... So in your case (note it is
usually safer to come up from the bottom)...

range(range("L3"), cells(rows.count, "A").end(xlup)).select

--
HTH...

Jim Thomlinson


"Arnie" wrote:

Guys i have a dynamic range that to find the last Cell with data in i use


Range("A3").End(xlDown).Offset(-1, 0).Select

i now need to select across to column L and up to Row 3 i have used

ActiveCell.Resize(1, 12).Select to select to column L but how do i
select up to row 3

Thanks in advance

Arnie