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