Hide/Unhide Rows Based On Cell Result

**stockjc** · 08-28-2012, 06:53 AM

Hi,

Im looking for some assitance in writing some code. I am very new at this so sorry if my question seems basic and easy but I have no idea where to start. Basically I am looking at writing code which does the following:

If A1 = 1 then hide rows 3:10, 11, 15, 19, 20:50 etc

If A1 = 2 then hide rows 3:10, 15, 29:52, 82

If A1 = 3 then hide rows 3:20, 95

If A1 = 4 then hide rows 8:10, 12, 14, 16, 18, 20, 22, 24:60

Now im able to get the first code which I have written as:

Please Login or Register  to view this content.

But as soon as I write the same again chaning 1 to 2, it seems to contridict itself and does nothing. Any help would be greatly appreciated as I really dont know what im doing lol.

Thanks

James

**arlu1201** · 08-28-2012, 07:08 AM

Try this

Please Login or Register  to view this content.

**Andrew-R** · 08-28-2012, 07:14 AM

It's hard to see why it wouldn't work if you added other values in, other than (as previously said) you might have to unhide all rows first.

How are you adding in the extra value checks for A1?

**stockjc** · 08-28-2012, 10:51 AM

Hi,

That worked great. Thank you ever so much for your help.

Im sure it wont be long till im back with some more easy help required.

Thank you

James

**arlu1201** · 08-28-2012, 11:28 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

**tjanda** · 08-29-2012, 09:37 PM

Hi: similar problem. Cell A3 contains values from 1-400. For select values (e.g., 1, 2, 6, 7, 9, ...)(35 discrete value) I would like to unhide rows 16:17 and 72:74. For all other values I would like these same rows to remain hidden. Any help on VB code to embed in worksheet is greatly appreciated. - TJ