Advice please for pasting correcyly as currently i see #REF!

[ipbr21054]

Afternoon.

A simple task isnt working for me.

I am trying to copy two values from one sheet & paste to another sheet.
The two values im copying have the =SUM in the cell

I copy ok but when i paste i see #REF!
The code in use is as follows,

Private Sub OneToTwo_Click()
Worksheets("ONE").Range("F16:F17").Copy Worksheets("TWO").Range("R9:R10")
End Sub

I think its due to the =SUM code but i tried special etc but didnt then get a paste value just another error.

What did i do wrong

Thanks

 

[My Aswer Is This]

Try this:

Private Sub OneToTwo_Click()
'Modified  5/8/2022  10:02:54 AM  EDT
Worksheets("TWO").Range("R9:R10").Value = Worksheets("ONE").Range("F16:F17").Value
End Sub

 

[My Aswer Is This]

Or use this:

Private Sub OneToTwo_Click()
'Modified  5/8/2022  10:16:54 AM  EDT
Worksheets("ONE").Range("F16:F17").Copy
Worksheets("TWO").Range("R9:R10").PasteSpecial xlPasteValues
Application.CutCopyMode = False
End Sub

 

[ipbr21054]

Many Thaniks for the reply.
Have a nice day

 

[My Aswer Is This]

Many Thaniks for the reply.
Have a nice day

Glad I was able to help you.
Come back here to Mr. Excel next time you need additional assistance.