Find the row of all cells in a selection

[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

 

[Alan Beban]

And another:

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

Alan Beban