| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
go to last record
What command will select the last record in a list?
Is there a way to include that command within a range? ie: Range ("A1:(last record)").Select Or better yet Range("A1:[last record]").AdvancedFilter... |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
go to last record
Did you have problems using the answer to your other thread
Use a dynamic range name http://www.contextures.com/xlNames01.html#Dynamic This will expand the range if you add records -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "keyt" wrote in message ... What command will select the last record in a list? Is there a way to include that command within a range? ie: Range ("A1:(last record)").Select Or better yet Range("A1:[last record]").AdvancedFilter... |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
go to last record
Let me know if this will work...
Range("A1:" & ActiveSheet.Cells.SpecialCells (xlCellTypeLastCell).Address).Select -----Original Message----- What command will select the last record in a list? Is there a way to include that command within a range? ie: Range ("A1:(last record)").Select Or better yet Range("A1:[last record]").AdvancedFilter... . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I need to have a record number change for every record | Excel Discussion (Misc queries) | |||
| Open new record with selected fields from previous record | Excel Discussion (Misc queries) | |||
| put each record on a new sheet | Excel Discussion (Misc queries) | |||
| Alt + Record | Excel Discussion (Misc queries) | |||
| Need help autopopulating next new record with previous record data | Excel Programming | |||
Linear Mode
