View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] EagleOne@discussions.microsoft.com is offline
external usenet poster
 
Posts: 391
Default Error proof way to find first blank Row after Autofilter Range

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