I have a worksheet where the dataset will never be the same from day to day.
I'm using filtering and I show only rows that do not equal a #N/A value.
I recorded a macro to delete the non-#N/A rows.
In this particular example, there are 101 rows to delete.
How can I - without arbitrarily tossing in some number like 150,000 as the upper limit - adjust for the exact size of the dataset as it increases or decreases?
I'm using filtering and I show only rows that do not equal a #N/A value.
I recorded a macro to delete the non-#N/A rows.
In this particular example, there are 101 rows to delete.
How can I - without arbitrarily tossing in some number like 150,000 as the upper limit - adjust for the exact size of the dataset as it increases or decreases?
Code:
ActiveSheet.Range("$A$1:$ZZ" & Last_Row_ColA).AutoFilter Field:=43, Criteria1:="<>#N/A"
Rows("2:101").Select
Selection.Delete shift:=xlUp