I am trying to write code to paste the contents of a range of cells on sheet
1 to a range of cells on sheet 2 but all it is pasting is a #REF error. I
assume this is becuase it is pasting the formula in the cells on sheet 1 and
not the values only. Is their a pasteSpecial method to paste teh values of
the cells only?