Multiple "ByVal Target As Range"

[batchy]

Hi,

I have a worksheet which has 2 fields (cells). When these values change i would like my VB code to hide a range of cells.

The 1st code works fine:

Please Login or Register  to view this content.

However when i add in the 2nd range it fails and not sure why?

Please Login or Register  to view this content.

[judgeh59]

From what I know WorksheetChange2 won't work....the system work recongize the "2"....but you can put the code from "2" into first one and it should work because you are looking at different cells....I think that should work....HTH

[batchy]

I have tried changing the name but still not working :s

[batchy]

Please Login or Register  to view this content.

i have tried putting the code in the same SUB but still not working

[judgeh59]

try this

Please Login or Register  to view this content.

[batchy]

I received an error

Compile error:

Block If without End If

[judgeh59]

Please Login or Register  to view this content.

[batchy]

Excellent many thanks what was the difference?

[judgeh59]

if the first attempt when you combined the two subs you put one IF statement inside the other....when I copied and seperated the two, I left out the last End IF...glad I could help....and thanks for the +rep