Dynamic Range

  • Thread starter Thread starter Arnie
  • Start date Start date
A

Arnie

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
 
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
 
Back
Top