Right then.....One Step forward....that as usual results in a step
backwards!
I have a file with 23 sheets, I copy 2 of them to a new file and then
try and remove all the formulae from the 2 copied sheets in the new
file. This results in it erroring while trying to replace the
formulae. So I tried running the loop that replaces the formulae on
the original file that contains all 23 sheets....success, no problems
what so ever. So, in defeat I have rejiged my macro to SaveAs the full
file and then delete the sheets I don't need and then run the loop to
remove all the formulae and success...I'm happy. BUT, it will always
bug me why it would fail to replace the formulae when the sheets were
copied!... I think it may have corrupted/caused problems to specific
copied sheets rather than what I originally thought, that it seemed to
fail on the last of the copied sheets.

Thanks for all your input and if you can suggest why my copy method
seems unstable then please let me know.
Donna