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...

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...

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...
.