VBA and merged cells really don't get on. The best advice I could give you would be not to use them.

Dom