Selecting A Range

  • Thread starter Thread starter russell \(skmr3\)
  • Start date Start date
R

russell \(skmr3\)

Hi Jason,

These two lines will select from the active cell, to the
end of the data range(i.e. last cell that has data, then
the same coloumn wise.

Range(Selection, Selection.End(xlToRight)).Select
Range(Selection, Selection.End(xlDown)).Select

HTH's.
Russ.
 
russel,

From what I iterpreted of the OP's post, he wanted from the
upper left of the range that he was in to the lower right and
not just from the active cell.

John
 
Back
Top