auto hide and unhide rows based on formula result in a cell

I have a spreadsheet that has a formula in K4 and so on that has a true or false statement.

If k4 is true, I want the row to hide and if it is false I want it to automatically unhide. The range is K4:K500

The formula results are based on data input on another spreadsheet. Can someone please write a code that will allow for this to happen automatically?

.
Paste into the Sheet Module :

Please Login or Register  to view this content.

Thank you, I am very much an excel vba code virgin. How do I have it run, it doesn't list it in the macros list?

No rows were hidden when I saved the code.

The sheet I am working with is the farm accounts.

.
Try now:

Originally Posted by Logit

.
Paste into the Sheet Module :

Please Login or Register  to view this content.

I am just trying to understand what exactly does the application.screenUpdating=false do?

Thank you but it's not auto unhiding? Also, how did you get it to run. I am a newbie at this.

.
Your original post said a "formula" approach vs macro. Although you did not explicitly indicate such, it lead me to believe you were using another formula or macro to paste the terms "True" or "False" into the specific cells.
Is this the case ?

If not, we will need to change the code and perhaps make it run via a Command Button.


Re: what does Application.Screenupdating do ? If FALSE it prevents any changes in the display (what you see on the screen) until the code gets to Screenupdating = True. Then, any changes that were created
from the macro code are seen at one time. Basically, it prevents screen flutter so any transition changes appear smooth - without flickering.

.
When the word TRUE or FALSE is placed in the appropriate cell, the row hides or unhides.

The cell where it says true or False is generated by a formula. The spreadsheet was only a few sheets of my entire spreadsheet so when I tried copying and pasting your code in my actual spreadsheet, nothing happened.

Of course as soon as I hit post reply, it starts working. Thank you for all of your help.

Did you paste the macro in the Sheet Level Module for Farm Accounts in the VB Editor ?

Farm.jpg

.
No problem.

I've had the same experiences. It's almost like Excel wants to embarrass me before it goes to working.

You are welcome.