I have this macro works fine, I just want to add 1 more criteria
the value in field 9 is empty but it has a formula like this =IFERROR(G224*H224,"")
Please Login or Register to view this content.
what do I need to change on this line :
Range("$A$1").CurrentRegion.AutoFilter Field:=9, Criteria1:="="
please help
. .
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
This will filter (hide) blanks including from formulas.
Please Login or Register to view this content.
that works! thank you AlphaFrog !
You're welcome. Thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks