Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|