Hi all,
I am using a simple copy paste code to get data from one sheet to another. I have formulas, so I want to paste only the result of formula
Now I get #REF error in the output cell. Is it possible to paste it only as the result of formula?
I am using a simple copy paste code to get data from one sheet to another. I have formulas, so I want to paste only the result of formula
VBA Code:
Worksheets("SUM").range("AX3:BA" & LastRowSum).Select
Selection.Copy Worksheets("LSMW ZVOL MAT PR GRP").range("A4")
Now I get #REF error in the output cell. Is it possible to paste it only as the result of formula?