hey all,
I'm learning VBA and I've been at it a couple of weeks. I've managed to make this monstrosity of a code somewhat work for me.
If a employee types their initials into column R and presses enter. that row will change to calibrated and it will get copied to a log from Column N:S
The problem I have is my coding skills aren't upto par, not everyone presses enter when they type their initals, some press tab or click off the cell so my reference to ActiveCell.Row is the weak link in the chain
Any help or guidance would be apperciated!
Code
Set BG = Range("N" & ActiveCell.Row)
Set EN = Range("S" & ActiveCell.Row)
Set SERange = Range(BG, EN).Offset(-1, 0)
Dim sh As Worksheet: Set sh = Sheets("Log")
Application.EnableEvents = False
Application.ScreenUpdating = False
SERange.Copy
lastRow = sh.Range("a1048576").End(xlUp).Row
sh.Range("A" & lastRow + 1).PasteSpecial xlPasteValues
Application.CutCopyMode = False
Application.ScreenUpdating = True
Display More