Automate answer to messages when copying and pasting cells

**mb1824** · 10-03-2018, 09:13 PM

Hi,

I have a macro to copy cells from one workbook and paste into another with the below code...is there a way to avoid having to manually select Yes and No to the 2 messages that appear (see screenshots below)?

Excel_copy and paste message 1.JPG

Excel_copy and paste message 2.JPG

Please Login or Register  to view this content.

**alansidman** · 10-03-2018, 10:34 PM

add this line of code at the beginning

Please Login or Register  to view this content.

**mb1824** · 10-03-2018, 10:41 PM

Thanks for your help, that works!

**alansidman** · 10-03-2018, 11:12 PM

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Automate answer to messages when copying and pasting cells

LinkBack

Thread Tools

Rate This Thread

Display

Automate answer to messages when copying and pasting cells

Re: Automate answer to messages when copying and pasting cells

Re: Automate answer to messages when copying and pasting cells

Re: Automate answer to messages when copying and pasting cells

Thread Information

Users Browsing this Thread

Similar Threads

Problem with copying and pasting. Is there another way to automate this? Maybe VBA?

[SOLVED] Macro to make copying cells automate,- an appeal for expert's advice!

[SOLVED] Need to automate the copying of range of cells into same row 365 times

[SOLVED] Need advice on how to automate copying one cell into many cells in Excel 2010

Matching cells between 5 worksheets and copying\pasting specific cells if match is made.

[SOLVED] In copy/pasting cells to a new sheet cannot automate cells (1, x) based on user input

Copying and Pasting Cells

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions