Hi all, I don't think this is a major functionality issue, but I am very curious as to why this is happening...
I have a simple code that works perfectly:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim KeyCells As Range
Set KeyCells = Range("A:A")
If Not Application.Intersect(KeyCells, Range(Target.Address)) _
Is Nothing Then
Range(Target.Address).Offset(0, 1) = Application.UserName
End If
End Sub
However, by pure chance, I noticed that if I highlight say A1:D5 and hit Delete (only delete does this) it pasts the name in every cell in B2:F5
why on earth does it do that? if i do the same thing but hit any other key it doesn't do that, but Delete does this weird thing?
Any insight is appreciated. Thanks
Bookmarks