PDA

View Full Version : [SOLVED] How to select all rows down?



roxnoxsox
10-30-2015, 07:49 AM
Sorry this is probably a really simple problem but I just can't wrap my head around it.

I'm trying to autofilter a large amount of data. I want this to work for all rows from row 2 down to the bottom of my data (this will vary) but I'm not sure what the formula for this is?

This is what I have so far:


Sub Macro1CONT()
Rows("1:1").Select
Selection.AutoFilter
ActiveSheet.Range("$A$1:$Q$19025").AutoFilter Field:=17, Criteria1:="<>"
Rows("2:19025").Select
Selection.Delete Shift:=xlUp
ActiveSheet.ShowAllData
Selection.AutoFilter
End Sub

SamT
10-30-2015, 08:55 AM
Range("A1").CurrentRegion.Offset(1).AutoFilt..........

roxnoxsox
11-02-2015, 02:14 AM
Thank you!