| 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 | |
|
|
Hybrid Mode
