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

J.E. McGimpsey wrote:
One way:

With Selection
MsgBox .Item(.Count).Row
End With

another:

With Selection
MsgBox .Row + .Rows.Count - 1
End With



In article ,
(TonyJeffs) wrote:


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