go to last record

keyt · Oct 9, 2003

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

Ron de Bruin · Oct 9, 2003

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

Patrick I. · Oct 9, 2003

Let me know if this will work...

Range("A1:" & ActiveSheet.Cells.SpecialCells
(xlCellTypeLastCell).Address).Select