Hi
Have code where I want an action to happen based on a cell value changing.
The code below works on other cells and sucessfully completes the action, however for some reason this specific cell range fails?
I cant give an example as it only happens on the actual worksheet( so cant share)
What elements should i look out for that make this fail ??
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$g$12" Then
Range("G20").Select
ActiveCell.Value = "=NOW()"
ActiveCell.Offset(0, 1).Value = Windows.Application.UserName
End If
End Sub
Bookmarks