Hi all,
I have a workbook which imports data from an external source on opening. Every time it imports data, I get the following message box appearing:
"This operation will cause some merged cells to unmerge. Do you wish to continue?"
Does any one know how to stop this message from appearing?
I was thinking something along the lines of Application.DisplayAlerts = False, but I'm unsure on how to apply it.
Any help please?
I have a workbook which imports data from an external source on opening. Every time it imports data, I get the following message box appearing:
"This operation will cause some merged cells to unmerge. Do you wish to continue?"
Does any one know how to stop this message from appearing?
I was thinking something along the lines of Application.DisplayAlerts = False, but I'm unsure on how to apply it.
Any help please?