How to fix macros in excel

Question

How to fix macros in excel

Roger Birch 0

Recently my simple macros have encountered a problem.

In excel I have a "template sheet" on which I have various designs (e.g. plain blue text box)

I created macros to copy these and paste them into an "ActiveSheet" using "ctr+a letter etc".

Now these have stopped working and when I instigate a macro, it has problem. I select debug and the problem appears to be "ActiveSheet.Paste"!!

I have not changed anything so I am at a loss why this is happening.

Any suggestions would be gratefully received. Thank you

Fernando Silva 0 Reputation points

2023-10-04T06:08:10.3933333+00:00

Try debugging your code. You will have a better view of the problem, and will be able to share more details about the problem.

Below is an example image, where the red band represents the checkpoint during debugging. And the yellow overlay represents the current moment of execution.
Olaf Helper 47,436 Reputation points

2023-10-04T06:26:32.1666667+00:00

Without a complete error message and the relevant part of your VBA code, no one can guess the cause.

1 answer

Your answer

Fernando Silva 0 Reputation points

2023-10-04T06:08:10.3933333+00:00

Try debugging your code. You will have a better view of the problem, and will be able to share more details about the problem.

Below is an example image, where the red band represents the checkpoint during debugging. And the yellow overlay represents the current moment of execution.
Olaf Helper 47,436 Reputation points

2023-10-04T06:26:32.1666667+00:00

Without a complete error message and the relevant part of your VBA code, no one can guess the cause.

Answer 1

Roger Birch 0

Thank you both for your response.

I am enclosing 3 screenshots - although in REVERSE ORDER.

"Screenshot 001" shows the simple shapes I want to copy and paste into an active sheet, i.e Sheet 2024. You will not the blue shape on the right "Blue Box" which I trigger using Ctr+i.

"Screenshot 002" shows the message I get having selected Ctr+i following which I select "Debug"

"Screenshot 003" describes the problem with the coding.!!

As previously mentioned, this has worked well for the last couple of years and suddenly stated to play-up last week.

I have updated my 365 app and thinking it may be a window's (W11) update problem, I have restored to a previous version but neither makes any difference.

If you require anymore information, please do not hesitate to ask.

Once again, many thanks for picking this up.

Screenshot 003

Screenshot 002

Screenshot 001

Viorel 122.5K Reputation points

2023-10-04T18:38:31.1633333+00:00

Does it happen with any shape and workbook?

Did you try to paste the shape to another sheet, or to check these operations (“Paste” at least) manually?
Roger Birch 0 Reputation points

2023-10-04T19:50:50.1233333+00:00

Hi, its does happen with other shapes, if I try to trigger the macro in another workbook I get "Run Time error 9 - Subscript out of range" which to me makes sense.

I can manually copy and paste to another sheet or workbook but get the same "paste" message when trying to copy to another sheet in the same workbook.
Roger Birch 0 Reputation points

2023-10-04T21:42:13.2233333+00:00

There is one thing to mention - If I perform the macro and get to the "Debug" window, I can select "Run"> "F5" and the process will continue as if nothing is wrong!! Hopefully this may shed more light on the problem.

Share via

How to fix macros in excel

1 answer

Your answer