Selection's first and last row
 

What is the best way to collect the first and last row numbers of a
currently selected area of a spreadsheet?

Selection's first and last row
 

If selection.Areas.count = 1 then
firstRow = selection(1).Row
lastRow = selection(selection.count).row
End if

--
Regards,
Tom Ogilvy

"Tim Coddington" wrote in message
...
What is the best way to collect the first and last row numbers of a
currently selected area of a spreadsheet?

Selection's first and last row - Thank Tom!!
 

Thanks, Tom

"Tom Ogilvy" wrote in message
...
If selection.Areas.count = 1 then
firstRow = selection(1).Row
lastRow = selection(selection.count).row
End if

--
Regards,
Tom Ogilvy

"Tim Coddington" wrote in message
...
What is the best way to collect the first and last row numbers of a
currently selected area of a spreadsheet?