copy + paste a merge cell

[ellehcer08]

hi there!

i want to create a button that will COPY the cells "Sheet1!A1:D2" to "Sheet2!A1:E1"... i tried recording a macro with that but i always get a WARNING... can someone please help me with this, i dont want that warning to pop up again... plz...thanks

 

[Smitty]

You can use Application.DIsplayAlerts = False to suppress messages. Just make sure to set it back to true at the end.

HTH,