Hiding/Unhiding Columns referencing a cell with a formula

[nabeel.pnm]

Hi all,


I have columns in other sheets to hide based on the the value of a cell in another worksheet.I got two drop down list in 1st sheet, each hides different column in sheet2 and sheet3. somehow i have ended with the code but It is coming up with a Compile Error: Ambiguous name detected: Worksheet_Change

code is

Please Login or Register  to view this content.

Any help would be greatly appreciated!!!

[MaczaQ]

see that you have duplicate line in the middle of your code ... so you starts two times the same SUB (it is impossible) and you have only one END SUB

Please Login or Register  to view this content.