Code running v slowly when Called from another Macro

Hi there, I'm creating a game in excel - I'm pretty new to vba code writing and have come across a problem that has me stumped...

I have some code as follows which takes approx. 30 seconds to run (ALLENEMYMOVE). However when I Call this at the end of another macro (AFTERFIGHTTOHOME) the same code now takes approx 5 mins to run. The cells altered by the (AFTERFIGHTTOHOME) macro do not affect the (ALLENEMYMOVE) macro so not sure what the difference is - if I run the two parts of code separately they execute quickly but putting them together seems to decrease the speed substantially. Any ideas why this is or how to get round this? Many thanks,

Theo

Please Login or Register  to view this content.

Please use Code Tags when posting code.

Click on Edit to open your thread, then 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

The first thing that comes to mind is that at the end of AFTERFIGHTTOHOME you calculate sheets Map.

At the start of ALLENEMYMOVE you calculate sheets Map again. What if you remove one of them ?

Glad to help and thanks for rep+.