Hi Peter,

Merged cells are a nightmare and should be avoided as much as possible
....
they were created for purely "cosmetic reasons" ...

However, to bypass your problem, try using SendKeys to skip the warning
....

HTH
Cheers
Carim