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