How do I change this to paste the values only? If I
put .PasteSpecial(xlPasteValues) at the end of each it says 'Unable to
get the PasteSpecial property of the Range class'.

SourceRange1.Copy DestRange1
SourceRange2.Copy DestRange2

Thank You,
-- Dan