Hide Rows based on Cell Value

**nogoodnames** · 04-21-2012, 10:36 AM

I'm having trouble with what I think should be some easy code.... and hoping somebody can help me.

I'm trying to input a Private Sub Worksheet_Change(ByVal Target As Range) to automatically hide/unhide some rows based on a cell reference (in my case it's just a drop down in the cell with either Yes/No). So, if the user selects Yes, it will show some rows, and if no, it will hide them.

I can get this to work just fine for one instance... but I want it to work in more than one instance. For example:

User selects Yes in C5, Show rows 6:10.
User selects No in C12, Hide rows 13:20
User selects Yes in C60, Show rows 62:72

No matter what I've tried, I can get C5 to work properly... but then nothing else works.

Anyone able to point me in the right direction?

Thank in advance!

**jraj1106** · 04-21-2012, 11:04 AM

Hi
Pls upload sample file

**arlu1201** · 04-21-2012, 11:06 AM

It will be good if you attach a sample file along with the code which you are using. Ensure that the sample file containing dummy data is in the same format as the original file.

**dilipandey** · 04-21-2012, 11:16 AM

Hi nogoodnames,

You can use below code:-

Please Login or Register  to view this content.

Sample file :- Hide rows based on value.xlsm

Regards,
DILIPandey

<click on below 'star' if this helps>

**john55** · 04-21-2012, 11:20 AM

try n see if it helps you

Later edit: too late!

)))

**nogoodnames** · 04-21-2012, 05:39 PM

Sorry I took so long to reply!

I can't attach a sample as the file is at work... and... well... I'm not.

My code looked very similar to Dilipandey's, but judging by his code, and from memory, it looks like I was putting my End If's in the wrong location.

However, both John55 and Dilipandey's work perfect for me, so thanks a million!