Save username and date
On Apr 29, 8:50*am, jlclyde wrote:
I woudl like to track changes as they happen to a sheet. *Not the
changes themselves but who actually changed them and when. *Something
like
Dim LstRw As Long
LstRw = Range("A65536").End(xlup).Row + 1
Range("A" & LstRw) = UserName and Now()
I am not sure how this is done.
thanks,
Jay
I found it. It is Application.UserName
Sorry,
Jay
|