I am trying to figure out why this code won't work.
It seems to do nothing at all.
I just want to understand how to build a code that updates data in a worksheet when any of the current data changes.![]()
Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = False On Error Resume Next Target.Value = "blah" Application.EnableEvents = True End Sub
For example, If someone puts the letter "x" in say... Cell F4, then Cell E39's value should change to "x"
Any Help Appreciated.
Bookmarks