Use vba to copy value of cell to another cell

Question

I have been having no luck finding a simple vba script that writes the value of a specific cell to another cell. I found below code here, but it doesn't seem to function. What I really want to do is constantly put the value of cell G22 in cell F15.

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("G22")) Is Nothing Then
    Range("F15") = Range("G22")
End If
End Sub

Sadly that won't work as my sheet is set up in such a way that would cause a circular warning reference. This really cannot be easily solved without remaking big parts of the entire worksheet, so I am hoping this would be a excellent short term solution. — user3730604
– user3730604, Commented Jun 14, 2014 at 13:33

edsolutions · Accepted Answer · 2014-06-14 13:38:42Z

1

This should work.

Range("F15").Value = Range("G22")

answered Jun 14, 2014 at 13:38

edsolutions

263 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Use vba to copy value of cell to another cell

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related