Hey Izandol,

Thanks for the reply. Unfortunately, it just copied and pasted the values (not the formulas) from 'FormulaRange' to 'DestinationRange'. I was having a look through the 'Range' object properties and methods and can't see anything that stores multiple formulas, just a single formula. But the formulas must be stored somewhere, maybe the clipboard? I'll investigate that option and reply soon.

Cheers, Rob