Macro: Hide Rows if Value in first column = 0

[Jamison]

Hi all,

I'm looking for macro to hide rows if the value in the A column is equal to zero. I have searched through many posts however each usually has a slightly different requirement/scenario which means the macros don't always work that well for my situation.

If possible, the macro should:

a) Run each time a particular cell is changed, either G9 or O9
b) Check the first cell of each row in column A (if possible, this would only apply to first 200 rows)
c) If the value is 0, hide entire row.
d) If the value is 1, unhide entire row.

Thanks for reading!

[Sa DQ]

Please Login or Register  to view this content.

[Jamison]

Please Login or Register  to view this content.

Hi Sa DQ,

Thanks for your reply.

Could you explain how to implement that macro and will it work on changing a particular cell?

[Sa DQ]

I can not help you because English too bad;

Mostly I use the FIND() method

[Winon]

Hello Jamison,

Say you do have a Cell in Column A which = 0, and a Macro hides the Row, as per your requirement, you would have to manually unhide that row to be able to enter a value in that particular Cell. Best bet would be to have two Macros which are "Fired" with the use of two Buttons. One Button to Hide Rows if criteria is met, and another Button to UnHide all Hidden Rows.

If you could upload a small sample WorkBook, I could see how best I may be able to help you.

[WasWodge]

Put this in a worksheet module (right click the sheet tab, click view code and paste the code in the window that appears)

Please Login or Register  to view this content.

Put this in a standard module (Alt+F11 key, click Insert then Module, Paste the code in the window that appears)

Please Login or Register  to view this content.

But as Winon says if A9 contains a "0" then cells "G9" and "O9" will be hidden. Are you sure that is what you want?
Also you didn't state what you wanted if the cells don't contain a "0" or a "1". I have assumed that you want those rows visible.

[WasWodge]

Thinking about it, it is better to replace

Please Login or Register  to view this content.

With

Please Login or Register  to view this content.

[Jamison]

Hi all,

Thanks for your help so far.

WasWodge, that works great! Thank you!

Updating thread to [Solved].

[beneheise]

I see the above data and am tryig to do a similar set up.
Inserting the macro into an excel contract that will display only rows that have merchandise with quantities greater than 0.
The macro when run will hide all rows with a 0 in C colum ranging between C4 and C66. i would like to link the macro to a button as well so when the user refreshes or ipdates data they can run the macro again
thanks in advance

[WasWodge]

You should have really started a new thread and if needed provided a link to the old thread but...

[Winon]

I agree with WasWodge, you should start your own Thread.


Maybe the attached WorkBook is what you are after.

[beneheise]

Thanks guys,
Just didnt want to upset the forum by posting another thread so similar. New thread posted!
Ben

[WasWodge]

We did both post answers in this thread in the attached sheets. We were both just advising you how you should do it in future before one of the moderators gets you. See the forum rules for more info

[beneheise]

Thanks! i see the replies now. i am sorry to say not quite sure how to integrate. will close this thread and reply in the correct one with the actual spreadsheet. thought i could be smart enough to import the macro from sample into actual
Guys thank you!