| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
find last used cell (row) in a named range
Hi, I am looking for a way to find the last used cell in a named range within a column. The following will work for an entire column:
Range("A65536").End(xlup).Select but when I change it to this,using a named Range, it will not work. Range("amount_local").End(xlUp).Select "Amount_Local" is part of one column. Can anyone tell me how to do this within a named range? Thanks, Harold |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find Cell in Named Range | Excel Worksheet Functions | |||
| find within a named range, then deselect the range | Excel Programming | |||
| inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) | |||
| Find first blank cell in single column named range | Excel Programming | |||
| Given a cell, find the named range it belongs to | Excel Programming | |||
Threaded Mode
