VBA to take result of SUM formula and paste into worksheet

[Stu Dapples]

Think I am losing the plot...

Simple - select a cell, copy - selct another cell in a different worksheet, paste.... Easy....

Origin cell has formaula in it (=SUM(A1:A5)

It copies OK but when I paste, I just get #Ref error - it is pasting the formula and not the value (so the cell now contains (=Sum(#Ref))

Tried PasteSpecial, Paste, xlPasteValues - nothing.... Am I missing something?!

Code:

Sheet3.Range("L28").Copy Sheet9.Range("K12").PasteSpecial = xlPasteValues

 

[Stu Dapples]

Which line of code is highlighted when you click debug?

Sheet9.Range("K12").PasteSpecial = xlPasteValues

 

[Fluff]

Remove the equals sign

 

[Stu Dapples]

I can't believe that took me so long!! That's what 5 years without coding will do - maybe time to go back to school....

Thanks Gents, much appreciated as ever

 

[Fluff]

Glad we could help & thanks for the feedback