Barry Katcher
Well-known Member
- Joined
- Feb 25, 2002
- Messages
- 4,053
I have a macro that uses the "Filter/Advanced Filter" function to first filter out all blank rows (no entry in column headed by "Fund"), then prints the sheet, then uses the "Filter/Advanced Filter" function to re-display all the blank rows.
My criteria for the first filter works fine and is cells A1:A2 and looks like:
Fund
>""
My criteria for the re-display filter bombs out. The macro doesn't display an error message, it just doesn't re-display the blank rows. The criteria is cells C1:D3 and looks like:
Fund Fund
>""
..........=""
What am I doing wrong?
_________________
I used to have delusions that I was a werewolf, but I'm much better noOOOWWWWWWWW!
This message was edited by Barry Katcher on 2002-09-19 10:58
This message was edited by Barry Katcher on 2002-09-19 11:24
My criteria for the first filter works fine and is cells A1:A2 and looks like:
Fund
>""
My criteria for the re-display filter bombs out. The macro doesn't display an error message, it just doesn't re-display the blank rows. The criteria is cells C1:D3 and looks like:
Fund Fund
>""
..........=""
What am I doing wrong?
_________________
I used to have delusions that I was a werewolf, but I'm much better noOOOWWWWWWWW!
This message was edited by Barry Katcher on 2002-09-19 10:58
This message was edited by Barry Katcher on 2002-09-19 11:24