Merge Cell Pop Up

[Pogboom]

i am getting this pop up not in every run .
I am using Vb code
If i Click on OK its changes the format
How to handle this?

[AJ_Ask]

Hi @Pogboom

You can add this line before your merge code in vba

Application.DisplayAlerts = False

By adding this line the pop up will not come.

Hope this helps