| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Get number of rows that data uses, including blank rows
but my solution gives you that,ie the row number of the last cell in the column that has data in it I numbered the rows purposely to give you a row number. It is the cell reference that I have enlarged that you need to put in your offset statement. -- robert111 ------------------------------------------------------------------------ robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996 View this thread: http://www.excelforum.com/showthread...hreadid=572977 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro question | Excel Worksheet Functions | |||
| How to number rows after data has been filtered? | Excel Discussion (Misc queries) | |||
| formula to use when number of rows changes dynamically | Excel Worksheet Functions | |||
| Removing blank rows in a worksheet | Excel Worksheet Functions | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Threaded Mode
