Thread: Trying to reduce the amount of times I have to press CANCEL

Hello,

I'm not quite sure the Word file with screenshots of the Excel file is helpful in solving this issue.

How about posting the Excel file instead, with the macro code that you are running?

Make sure to replace confidential data with dummy data.

And finally: you seem to be using merged cells. If so, don't. They cause all kinds of trouble when macros and other native Excel functionality is involved.

cheers,

There are no macros in that attachment.

Can you take a few steps back and describe what you would want your macro to do instead of complaining about what you imagine a non-existent macro might do?

As far as I'm concerned, your fears are unfounded, since you have not provided a macro that requires to hit Cancel xxx times.

So, let's start over.

What do you want to achieve? Describe the desired outcome. Don't worry about what macro steps may be required.

Then again: your use of merged cells in the sheet may be preventing any macro solution from working. Do not use merged cells is one of the first unspoken rules you will find the advisors here agree on.

Maybe you shouldn't use 'copy/paste' (including the copying of formulas, that contain references to external workbooks), but 'copy/pastespecial xlvalues' instead.
Or you could transfer the values directly using:

Workbooks(2).range("A3012:G3022")=Workbooks(1).range("A3012:G3022").value