Macro Slows Down for no Reason

[Jeckford]

I have a macro which runs about 6 functions. Besides the last function, each function takes less then 1 second to complete. The last function however is taking over 30 seconds to complete (I timed them all). When I put a 'Stop' at the 6 function and then hit play again, the 6 function will then also take less than 1 second to complete? Does anybody know what would be slowing down the macro?

 

[MARK858]

Does anybody know what would be slowing down the macro?

Without you posting the macro I doubt it.

 

[FDibbins]

x-posted here
https://www.excelforum.com/excel-programming-vba-macros/1212551-macro-slows-down-for-no-reason.html

 

[Jeckford]

As soon as I realised I posted on the wrong site, I went to delete it, but couldn't figure out how. This is why my question is posted on two sites.