The simple answer is 'do not use merged cells' - browse the web for reasons not - they have no place on an Excel app - especially if you are using VBA to expedite actions.