workbook change events not working together

[robtuby]

Hi

I have these which work perfect apart but when i try and get them to work together they loop and crash

It should be doing the following:
When a user selects a cell it expands to the column width 33.
then applies the data validation list using the named "Schemes"

The reason for the dose is the expansion of the column is really nice and the data validation is to compensate for if a user merges then unmerges a cell it repopulates the data validation

any ideas?
code is below

Please Login or Register  to view this content.

[TMS]

If you select a range in the Change event handler, the Selection Change event handler will fire. You have to stop it doing that.

Please Login or Register  to view this content.

Regards, TMS

[robtuby]

Thanks but i still cannot get it to work correctly

Did i place it in the right place?

Please Login or Register  to view this content.

If you select a range in the Change event handler, the Selection Change event handler will fire. You have to stop it doing that.

Please Login or Register  to view this content.

Regards, TMS

[TMS]

No, you have to put it around the actual selection, as I have done, not the comment

But thanks for the rep.