Ways to make my code run faster

Hello,
Any way to make this code run faster?
Thanks

Please Login or Register  to view this content.

Jazz,
Could you please use code tags? Could you edit the above code while I look at your code?

Please Login or Register  to view this content.

Hi, JazzyBear,

Posting code in [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here.

Two alternatives (as you have not posted all code):

Please Login or Register  to view this content.

Assuming that there are constants in Column A:

Please Login or Register  to view this content.

And you could try Application.ScreenUpdating = False at the start of the code and ~ = True before closing down.

Ciao,
Holger