VBA Speed Query

I suspect when you run using F5 key, you may have an active sheet name or range in your code and your cursor may/ may not on the active sheet/range.

I've noticed the speed changes & I don't know why. There's two workbook open at the time the macro runs with data going from one to the other & I've minimised the activations. It's obviously something I'm doing if it's supposed to run at normal speed via F5.
If/when I find it I'll post back to let anyone who's interested know

If you open the two books at the same time, I suspect one of the books may be active book. And when you are using F5, you may unintentionally changing the active sheet name. Pressing a button run smoothly as you are not touching any of active sheet names and range.

It is most likely that your code has got an error and may not be obvious to see it.

Thanks for the replies. I found 2 things.

1) If I fully qualified the code, I don't need activations (There were only a few). I presume by doing that it stopped excel from working out / guessing what I was referring to, as well as telling it where to go in the nicest possible way & removing any wrong referencing

2) I found the module when exported was 63k in size. I've read that excel has a hernia when it gets near 64k. I split that in two & now have two roughly 30k modules + the variables module.

All is well & speeding along nicely.
On to the next project now
Cheers