If you use Paste Special rather than just Paste, then you have the option to Skip Blanks (bottom left corner of the dialogue box), which prevents empty cells from the source range overwriting values or formulae in the destination range. So, you just have to ensure that where your formulae occur on the destination sheet, there is no data in the source sheet.
Hope this helps.
Pete
Bookmarks