View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
jlclyde jlclyde is offline
external usenet poster
 
Posts: 410
Default 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