Hi

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

Worksheets("NC").Cells(i, 47).Copy Worksheets("TaskDashboard").Cells(j, 5)
it returns #REF

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

=IF(P19="","",IF(IFERROR(ReturnNoteText(P19),"")="","",ReturnNoteText(P19)))
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