[daplunk]

That's the answer although its not the complete answer!

Copying like that simply replicates the excel copy function. Thus is copies the formulas. So it doesn't work on most of it. It does work on the bits I'm having trouble with. So now I just need to create two separate parts of the copy process.

One for this bit and then a different one for the bits that dont have formatting but have formulas.

Thank you!