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

criteriarange not equal to	4	Jun 20, 2011
Applying Variables to SORT	4	Aug 11, 2014
VBA set thick borders around non empty cells in range	0	Jun 8, 2021
Filtering multiple sheets	5	Jan 18, 2009
End(xlDown)	5	Jul 13, 2009
Conflict	8	Jan 2, 2015
"Run-time error '1004'	5	Jun 13, 2012
A1:B(xlDown)?	4	Jul 28, 2008

Ask a Question