I'm new to vba, and appreciate any help.
I'm trying to clean up several long worksheets by removing rows that don't contain a visable number or letter. I want to remove all rows that only contain either empty cells, formulas that evaluate to a empty text string (""), cells that contain error values, or cells that contain zeros, or any combination of the previous. I've stumbled onto the following, but it does not work.
Am I on the right track? Can anyone help modify this or offer a better solution? Thanks in advance.
Bookmarks