Hide empty cells with "" in them

  • Cell has =+IF(A21<=$A$20,VLOOKUP(A21,Inputs!$N$17:$O$26,2,FALSE),"") in it; however, when the cell is false and turns out "", which is nothing in the cell, how do I hide/delete the rows?

  • If you use On Error Resume Nextyou must be very carefull with your spelling.

    Have you tried:


    instead of:

  • What is not working?

    You need the error handler in case there are no blank cells. Run the code without the error handler to see if any error messages are shown.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!