macro won't auto trigger on cell change

Afternoon,
I have a spreadsheet with rows 20 - 34 having two merged columns B-E and F-J (I know nobody likes merged cells, but i need it to be this way as the people who are using the spreadsheets are proper novices and therefore rubbish at entering information correctly.)
I have managed to cobble together a macro that auto adjusts the height of the columns to auto fit the text.
This works by comparing the merged active cell text length LEN with the other in the same row and if it has more text then adjusts the height to fit. See the code that compares and trigger the actual resizing code below:

Please Login or Register  to view this content.

and that triggers the code to actually do it.

Please Login or Register  to view this content.

to get it to work I am having to trigger it from the worksheet_selectionchange. This only works when you click on the cell and not when you add/remove text.
I have tried triggering from worksheet_change, but absolutly nothing happens (not when you type, not when you click.)

does anyone know why and how to fix it? This is sending me absolutly mental.

Thanks in advance.

Is the code actually being triggered?

You can check that by putting a breakpoint on the first line with F9, and then goto the sheet and select something in the range you are monitoring.

Another thing to check is that events are enabled, they might have been disabled at some point and not re-enabled.

To do that goto the VBE, open the Immediate Window (CTRL+G) and enter this.

Please Login or Register  to view this content.

If that returns False events are disabled, re-enable them by entering this.

Please Login or Register  to view this content.