| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find last non-blank cell in range | Excel Discussion (Misc queries) | |||
| Find within range & Replace with Blank Value | Excel Discussion (Misc queries) | |||
| How do I find the next blank cell in a range? | Excel Worksheet Functions | |||
| find range of non-blank cells in colum | Excel Programming | |||
| How to find the first blank cell in a range | Excel Programming | |||
Threaded Mode
