Solved by referencing the current sheet rather than the ActiveSheet each time!

Thanks for all help received