Hide columns if the cells in a specific row are blank.

  • I need to hide all columns (A through ADO) if the corresponding cell in row 58 is a blank. Please provide direction.


    Thank you
    B

  • Re: Hide columns if the cells in a specific row are blank.


    So to clarify if cell F58 is a blank then hide column F. If cell G58 has text or a number the do not hide column G. Do this for all cells in row 58 columns A through ADO.


    Thanks again
    B

  • Re: Hide columns if the cells in a specific row are blank.


    Try this


  • hi this code is very helpful!!


    Could you write how this could work, if the number of row is the result of a match function?


    for example a have a table, I find the number of the row that has a specific value and then, I want to hide all the columns that has blank cells in specific row.


    Thanks in advance!!


    P.S : Sorry for my english

  • Welcome to the Forum


    Please start your own post. Posting in another member's Thread is known as hijacking and is not allowed here. By all means add a link to a Thread that may be related to your question.

Participate now!

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