| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
number of rows in spreadsheet
How can I determine the number of rows in a spreadsheet useing visual basic. This number is dynamic and will be used to determine the end of a loop
seeker52 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
number of rows in spreadsheet
In general an approach is:
assume column A can be used for this purpose set rng = cells(rows.count,1).End(xlup) msgbox "Last row is " & rng.row -- Regards, Tom Ogilvy "seeker52" wrote in message ... How can I determine the number of rows in a spreadsheet useing visual basic. This number is dynamic and will be used to determine the end of a loop. seeker52 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sum the number of rows in a spreadsheet given 2 criteria??? | Excel Discussion (Misc queries) | |||
| How to number lines (rows) on both sides of spreadsheet | Excel Worksheet Functions | |||
| What is the maximum number of rows in an Excel spreadsheet ? | Excel Discussion (Misc queries) | |||
| cells() and counting number or rows on spreadsheet | Excel Worksheet Functions | |||
| How do I limit number of rows and columns on a spreadsheet | New Users to Excel | |||
Hybrid Mode
