| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to find the number of used rows in a spreadsheet?
Hi,
I have a FOR NEXT loop that runs for each row in a sheet. However the number of rows changes so I keep having to go in and type the new number for eg if there are 80 rows I type For i =1 to 80 Is there a way of substituting the 80 dynamically so excel knows how many rows there are on a spreadsheet. This would help me out greatly. Thanks for any help Sandra |
| 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) | |||
| Need to find all instances of a ticket number in a spreadsheet | Excel Worksheet Functions | |||
| 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) | |||
| number of rows in spreadsheet | Excel Programming | |||
Threaded Mode
