View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jlclyde jlclyde is offline
external usenet poster
 
Posts: 410
Default Save username and date

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