roxnoxsox
02-05-2015, 05:40 AM
I have a spreadsheet where if a button is pressed, it will show cell A1 of sheet2 in cell G1 of Sheet1.
The code I'm using to do this is:
Sub CopyData()
Sheets("Sheet2").Range("A1").Copy Sheets("Sheet1").Range("G1")
End Sub
However, at the moment this is just copying the formula from A1 of sheet2. How can I modify this so that is just shows the value not the formula?
The code I'm using to do this is:
Sub CopyData()
Sheets("Sheet2").Range("A1").Copy Sheets("Sheet1").Range("G1")
End Sub
However, at the moment this is just copying the formula from A1 of sheet2. How can I modify this so that is just shows the value not the formula?