How to Macro: if...then unhide row?

[mattjac]

Hi I'm very new to this forum and I wish I knew more about macros as they are awesome but alas I am not.
I wish to create an IF a certain cell is > 0, then unhide row function.
Unfortunately I understand that innate excel functions can't accomplish this, so is there anyone who would know how to create a macro to do this?

The specifics are:
If cell Q85 OR R85 within "worksheet_1" is > 0, then unhide row 60 within worksheet "worksheet_x".
I will be using many more cells for more columns - i.e. Q85/R85 within
"worksheet_2" to unhide row 61 within worksheet "worksheet_x".
I also want to go Q86/R86 within "worksheet_1" > 0, then unhide row 70 in "worksheet_x".

If it makes a difference, I will drawing information from 9 different worksheets and directing their inputs to one worksheet (worksheet_x).

Please let me know if this confuses you, I tried to be somewhat clear despite my lack of comp-sci savvy. Thank you in advance for your help!

[davegugg]

Here is a custom procedure that will do what you want:

Please Login or Register  to view this content.

This way you can run it by entering the arguments you want and change them up easily as needed. For your first example, you'd call it like this:

Please Login or Register  to view this content.

Your next example would be called like this:

Please Login or Register  to view this content.

Then:

Please Login or Register  to view this content.