Hi,
I am trying to copy only the values (NOT the formulas) from one location to another. My current code is:
Obviously, this only copies formulas. Could anyone be so kind to tell me how to change this to copy values only?
Thank you.
I am trying to copy only the values (NOT the formulas) from one location to another. My current code is:
Code:
With Sheets("Main Page")
.Range("G12", .Range("G" & Rows.Count).End(xlUp)).Copy _
Sheets("Comparison").Range("B" & Rows.Count).End(xlUp)(2)
End With
Obviously, this only copies formulas. Could anyone be so kind to tell me how to change this to copy values only?
Thank you.