Easier Way to do it?
Thank you very much.
"Yngve" wrote:
Hi Kurt Barr
If you are going to keep Paste:=xlPasteFormulas
Sheets("Form Data").Range("C3").Copy
Sheets("New Deal Data").Range("AA5").PasteSpecial
Paste:=xlPasteFormulas
if it`s only value then
Sheets("New Deal Data").Range("AA5") = _
Sheets("Form Data").Range("C3").value
Regards Yngve
|