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.
Bookmarks