Hey all, I'm trying to have excel insert a timestamp on a specific range of cells. I have it currently working on one cell, but can for some reason am having trouble getting it to work on the entire range... Here is what I have currently...
I would like this to work for the range E23:E28 and F23:F28 I'm sure its something simple that I'm not doing... any help?PHP Code:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Target.Address = "$E$23" Then
Target.Value = Time
End If
End Sub
Thanks!
Bookmarks