Worksheet_Change across multiple Column ranges does not trigger Macro and Macro fails

[Trompie]

Hi,
I have a spreadsheet that on a change in a column range triggers a macro to unhide a specific row on another sheet that works.

However, I need the change to trigger from other column ranges on the same sheet.

Worksheet_Change that works :

Please Login or Register  to view this content.

Worksheet_Change that does not work for other column ranges is :

Please Login or Register  to view this content.

The called macro is fairly long but follows the below example :

Please Login or Register  to view this content.

This goes down to row 52.

Likely that the method I have used has resulted in being somewhat bloated.
I have a sample file if that will help.
Any suggestions from the Forum??

Trompie

[rorya]

You need to remove the last comma and space from the range address.