The VBA code below that goes into the worksheet, hides rows that contain 0 or "" blank. And unhides everything else. It works good. However...
--------------
FIRST OF ALL:
It only looks for NUMBERS not text. So, if a cell contains TEXT and not a number, then it is hidden too. But that's not good for me, because I need it to look for both numbers or text. If "" blank then hide, if there is text or numbers then unhide. Help me fix that please!
Please Login or Register to view this content.
-----------------------
AND SECONDLY:
It will not allow me to just select Col "A"... I have to have a range like A:B... I managed a way around that, but if the code can be fixed that would be better. What I did is add a new column that is always blank, and hid it....
When I edit the code to:
Then an error comes up saying:Please Login or Register to view this content.
"Run-time error '13':
Type mismatch"
I'm a layman to coding... So, can you please send me a new code that will work for me?\
Thank you!
Bookmarks