go to last record

[keyt]

What command will select the last record in a list?

Is there a way to include that command within a range?

ie: Range ("A1last record)").Select

Or better yet Range("A1:[last record]").AdvancedFilter...

 

[Ron de Bruin]

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

Let me know if this will work...

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