Find the row of all cells in a selection

  • Thread starter Thread starter TonyJeffs
  • Start date Start date
T

TonyJeffs

If I select a block of cells, C14:F19
- and then run a subroutine:

msgbox selection.row

-That would read 14, the first row in the selection.
but how can I obtain the last row in the selection?
...................


Thanks
Tony
 
And another:

Selection(Selection.Rows.Count, 1).Row

Alan Beban
 
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

Apply Alternate Shading to selected rows 2
How do I count the number of rows selected? 3
Last Row of Selection 3
Changes in How Code Acts After Upgrade of Excel 2
Adding a row with the previous one if.... 1
How to get the last row in a column without selecting 2
Code to add comments to selected cells within a selected range 30
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0

Back
Top