Build code to do Advanced Filter with the criteria range 0
Do this manually with the recorder on, than edit the recorded code.
--
steveB
Remove "AYN" from email to respond
"manjukhan" wrote in
message ...
I need to filter a column for non blanks and list the values on a
different column. I can do this by doing a autofilter and filter for
non blanks . But I want to do it automatically with a formula. Do any
one have a formula accomplish this.
Thanks
Mansoor A Khan
--
manjukhan
------------------------------------------------------------------------
manjukhan's Profile:
http://www.excelforum.com/member.php...o&userid=25268
View this thread: http://www.excelforum.com/showthread...hreadid=387567