Set of macros giving out of stack space error

Hello,

I wonder if someone can help, I have the below set of macros that run for a few hours and then give run time error out of stack space. Can anyone see what the issue is?

I'm pretty certain that it's not the cleanest way to do what I need, so an alternate way can be suggested if that's easier. I'm basically just wanting it to loop through activating 3 sheets and then refreshing the data once in each revolution

Please Login or Register  to view this content.

Thanks in advance for any help!

Assuming no one changes the active workbook to another, the following code should be more secure (though not perfect!)

Please Login or Register  to view this content.

Artik

Thanks Artik, I'll give it a go