VBA Auto Hide/unhide row

I'm building a spreadsheet in which I would like to have some rows auto hide and unhide based on a value in a separate cell and have a two part question.

For example, if cell A5 = "", then auto hide row 12. Below is the code I've done so far that works in part.

Question 1. I can get the code to work by manually clearing cell A5. However, I want to go a step further by having a If statement in A5 ,for example, =if(a1="x","x",""). As soon as I add the IF statement to a5, the auto hide/unhide no longer works. Although my target cell A5 is technically blank from visible view, it's like the VBA is seeing the IF statement as not blank or "". Is there a way to make this work if the target cell A5 has an if statement that results in a blank?

Question 2. How would I go about adding additional unrelated target cells and result rows? Example, if cell A6 = "", then hide row 13.

Please Login or Register  to view this content.

I've changed to a worksheet calculate. I was able to get my rows to hide/unhide with one caveat. At the moment, all cells from A4:A15 show an X if A3 has an X. =if(a3="x","x",""). A16 will only show an X if C15 meets a certain condition. If I make that condition true, and in turn make A16 have an X, I can't seem to get the VBA code to unhide it's line. Is it possible that the A16 x doesn't exist until after the code runs, and thus does not unhide the row?

Please Login or Register  to view this content.

Originally Posted by skywriter

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Maybe I had a bad excel day, but now it's working. I changed my secondary's to an if/and with a reference back to my initial line. Now my secondary's are closing and opening as they should be. I'll dink with it some more over the weekend when I get some spare time to see if all stays well. If I run into issue, I'll create a new sample worksheet to upload for review.