vba copy value only instead of formala getting runtime rrror

[JEAN1972]

I have a workbook with worksheets
One sheet Page_1
One sheet Corps
However when my macro copies it copies from sheet corps to new sheet but there is a formula in sheet Corps which is linked to page_1


gives this on copied sheet=Page_1!#REF!

How to modify this in vba to copy only value
I have tried .value after A2

runtime error1004 copy method range class failed

Thanks if anyone can assist

Please Login or Register  to view this content.

[AB33]

Change

Please Login or Register  to view this content.

[JEAN1972]

Change

Please Login or Register  to view this content.

Thank you