Easy macro to hide rows

[Rahul15292000]

Dear VBA Gurus,

I need help with a small macro.

Based on value of cell (A15) i.e. 1 or 2, rows 15,16,17 & 18 need to get hidden.

So if the value of cell A15=1 then hide rows 15,16,17 &18

But if the value of cell A15=2, then unhide rows 15,16,117 & 18.

Thanks for your help
Rahul

[YasserKhalil]

try this

Please Login or Register  to view this content.

But I suggest to put the value in any other row as if the value was 1 then rows 15 will be hidden
so you can't change the value of A15

[Joakim N]

Please Login or Register  to view this content.