I want a macro to copy cells A1 to P392 from one Workbook to another.

However when I run the macro I get the automatic Excel dialogue box
reading,

"There is a large amount of text in the clipboard. Do you want to be
able to paste this information into another program later?

for which I have to click YES for the rest of the macro to run.

- Is there any way I can get the Macro to click YES for me? or

- Is there any other way I can transfer these cells other than the
COPY and PASTE command?

Kind regards

Ian M