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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

File Name changes with dates and Deleting Rows of Zeros 0
copy range to a variable. 6
select pivot table range 1
fit to one page 1
Naming variable range selected by cursor movement 2
Sort current range by column j 1
Excel Macro to use cells as a autofilter 0
Insert cells 1

Back
Top