Hi,
I have a problem that I'm sure someone will know the answer too.
I've come pretty close but still not got what could be a simple answer.
I have an Automated Advanced filter with drop down menus for all but one of the criteria.
I have a "free" field so that someone can type in a Rep No or leave it blank if they wish.
I tried a Data Validation list with a blank and tried using ISBlank, no joy.
It just returns the headers only and breaks the filter.
The only way I can start it again is to alter the range in the code to exclude the Rep No, then it's fine again.
I'd like to be able to skip over the criteria from any one box if it has nothing inside it.
Any advice much appreciated.
Thanks
Bookmarks