Forum Discussion

Copper Contributor

Feb 23, 2023

Copy and Past a Cell Content in another cell with formula

Hi Guys, I was wondering if you can advise me on how can I copy and paste just the value of one cell into another cell using an excel formula. Thanks Mehran

excel

Formulas and Functions

Mehran1359

Copper Contributor

Feb 23, 2023

Thanks for your reply. With this method, I am moving the cell A1 formula to Cell B1.
I am looking for a method to just copy & past the value of cell A1 to B1. Exactly the same as when we copy and paste only the cell value.
I like to break the connection formula between A1 and B1.

FikturFox

Brass Contributor

Feb 23, 2023

Mehran1359

If that is the case, a formula cannot do this. Instead, use macro/vba script.
ie

Sub Test()
Range("B1").Value = Range("A1").value
End Sub

This procedure will copy the value in A1 to B1.