Hide/Unhide row based on given criteria w. no Trigger butn

Good day all!

I am after a macro that can hide or unhide a row if cell A# contains a trigger variable.

EXAMPLE:

Row 1: if A1=1 then HIDDEN row

Note the following:
- A1 contains a formula, which achieves the number 1.
- If A1 were to change back to say 0, row needs to be UNHIDDEN.
- I'd prefer it if it would automatically refresh (and no need for the macro to search through all 21957129837 rows, just a range, say 1:99999.

Also this should be done automatically i.e. no trigger buttons but the formula within the trigger cell.

Hope this is enough information.

Thanks guys! Your help is much appreciated
Dan

If you require an example spreadsheet please let me know

I found this code which does the trick BUT it hides or unhides a certain range. I want it to hide / unhide a row subject to the first cell value.

Please Login or Register  to view this content.

Do right click on sheet tab and select view code and copy and paste the below code in Code Window

Please Login or Register  to view this content.

It's working fine for me check whether the calculation of the workbook is set to automatic

Hi

Try this one:

hideunhide.xlsm

Sorry I don't know anything about Mac

Try this....

Do right click on sheet tab and select view code and copy and paste the below code in Code Window

Please Login or Register  to view this content.