Using Multiple Private Sub Worksheet_Change (ByVal Target As Range)

[kcmick87]

Hello All,

I am very new to VBA and am really hoping someone can help me.

I am trying to create a worksheet that hides different rows depending on the drop down responses in various cells ie. please select, yes, no. The first drop down works but when I copy the code for the second drop down, the second drop down does not. Please help!

 

[Candyman8019]

I would change your target lines as follows:

if not intersect (target, range("C13")) is nothing then

similarly

if not intersect (target, range("C36")) is nothing then

This way, the event will do nothing unless either C13 or C36 were changed.

 

[kcmick87]

I would change your target lines as follows:

if not intersect (target, range("C13")) is nothing then

similarly

if not intersect (target, range("C36")) is nothing then

This way, the event will do nothing unless either C13 or C36 were changed.

Hi thanks for your help!

Now I am getting a Compile Error" Block If without End If

 

[kcmick87]

Hi Everyone I was able to figure it out by specifying the range