Macro is using 51% CPU and I don't know why.

[retireme]

I originally created 7 macros to automate certain repetitive actions.

I created a new macro to run all the other macros if I so desired.

I then noticed that my screen became jerky and slow cursor movement whilst using this spreadsheet.

On investigation, I found one of the macros was the culprit but I am at a loss to explain why. It increases the CPU usage from 1% to 51% and remains that way until I shut the spreadsheet down.

I know the code is amateurish and I apologise in advance. However, I would appreciate any help to isolate where the increase and sustained CPU usage is coming from.

Thankyou

The following is the code:

Please Login or Register  to view this content.

[royUK]

You really need to edit recorded macros, unnecessary Selecting etc will slow down your code. I think I have followed what you are doing and amended the code

Please Login or Register  to view this content.

[retireme]

Roy,

I understand a little better now. It will still need some tweaking as the row length is variable (hence selecting a full column) but I will soldier on.

Thank you for your time and effort.

Nick

[royUK]

Why does the Row length determine that you need a full column?

Maybe an explanation of what you are attempting might give us a chance to offer a better solution.