Making rows invisible with VBA

Hi, I have a cell range from A18 to A49, and I want a macro to hide the rows that have zeros in them. For example, if the value on A24 is zero, row 24 would be hidden. But if the value on A24 changes to a number later, row 24 would show up again.

Now I guess you can already tell I am a beginner at VBA. I thought of a macro like this:

Please Login or Register  to view this content.

But repeating those lines from A18 to A49 seems pretty tedious. Is there a faster way to do this?

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

Code tags added this time only.

How does the value of a hidden cell change?

try this (given the values in A are determined by a formula and the macro is kicked off manually)

Please Login or Register  to view this content.

How will the cell values change?

Roy, in my scenario I decided that the cell values were determined by formulas, so the problem of accessing a hidden cell to change its value back to something other than zero did not manifest.

I realise it would probably be a formula, in which case the calculate event could trigger the change.

True. I have not used that event so far, but will expand my horizon.

So, something like this in the Sheet module

Please Login or Register  to view this content.

Can shorten the code a wee bit just using:

Please Login or Register  to view this content.

Palmetto,

good point. To clarify for the OP's benefit (and to reinforce my own learning):

the code bit ...

Please Login or Register  to view this content.

... will result in eithert TRUE or FALSE, thus yielding

Please Login or Register  to view this content.

Nice!