I have a Master Macro in a workbook and it runs multiple smaller subs in sequence order by using 'Call' in order.
One of them works 100% as it should when running individually but when running in the sequence it doesn't do what it is supposed to.
I've used a Stop right before it starts to be sure all the data is there that should be and it is. Typically then if ai run it after the Stop then it works. Or if I fully stop the sequence and run it on its own it also does its job properly.
I don't think posting code is really going to help here as it is effective when run individually.
Is it possible I need to have it wait from the last sub prior or what may be a solution here?
One of them works 100% as it should when running individually but when running in the sequence it doesn't do what it is supposed to.
I've used a Stop right before it starts to be sure all the data is there that should be and it is. Typically then if ai run it after the Stop then it works. Or if I fully stop the sequence and run it on its own it also does its job properly.
I don't think posting code is really going to help here as it is effective when run individually.
Is it possible I need to have it wait from the last sub prior or what may be a solution here?