Paste values does not work for Worksheets.Cells.Copy

[Paul-K]

Hi

I have below line of code for copying data from one cell to another:

Please Login or Register  to view this content.

it returns #REF

Source cell has formula including function (ReturnNoteText) as I get the data from cell note.

Please Login or Register  to view this content.

I have value in a cell but when copying it returns #REF.
I checked a lot of variants with paste values and using range instead of cell as well, but no effect :|

I count on your help

[romperstomper]

You can't copy the formula since it uses relative addressing to refer to a cell 30 columns to the left of the formula cell, but you are pasting it to column 5. If you want to just copy the values, you can just assign them directly:

Please Login or Register  to view this content.

[ByteMarks]

What about.

Please Login or Register  to view this content.