E
EagleOne
2003/2007
Attempted:
With Filter:
wks.Cells(Rows.Count, "D").End(xlUp).Row = 184
After removing the Filter:
wks.Cells(Rows.Count, "D").End(xlUp).Row = 331
What can I use the make sure that I get 331 Filtered or Not Filtered?
What I want is the Row number of the first available totally-blank row
assuming that all previous rows are not blank.
I realize that I could filter for blanks and maybe that is an answer.
Prefer not to Filter A; Un filter A; Filter B; Un filter B; Filter A
TIA EagleOne
Attempted:
With Filter:
wks.Cells(Rows.Count, "D").End(xlUp).Row = 184
After removing the Filter:
wks.Cells(Rows.Count, "D").End(xlUp).Row = 331
What can I use the make sure that I get 331 Filtered or Not Filtered?
What I want is the Row number of the first available totally-blank row
assuming that all previous rows are not blank.
I realize that I could filter for blanks and maybe that is an answer.
Prefer not to Filter A; Un filter A; Filter B; Un filter B; Filter A
TIA EagleOne