Selection's first and last row

  • Thread starter Thread starter Tim Coddington
  • Start date Start date
T

Tim Coddington

What is the best way to collect the first and last row numbers of a
currently selected area of a spreadsheet?
 
If selection.Areas.count = 1 then
firstRow = selection(1).Row
lastRow = selection(selection.count).row
End if
 
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

Taking the 51st Line and Multiplying by 2 8
Autofill Question 4
Code Snippet - Data Filter 8
Delete rows takes forever 4
Paste in column B using Last row of either column B, C or D. 10
Copy .Areas.Item(1,2,3,4,5, etc.) to a column or a row 5
first and last row of range 5
Copy rows and insert (x) number of times 4

Back
Top