Thread: Selection's first and last row
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default 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?




Reply With QuoteReply With Quote