View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ozgrid.com ozgrid.com is offline
external usenet poster
 
Posts: 464
Default Macro for Time Recording

If Range("A1")< val Then Range("A2")=Time


--
Regards
Dave Hawley
www.ozgrid.com
"karim" wrote in message
...
hi,

I want to record current time into cell(A2) when cell (A1) does contain
value with macro.
I want to record it automaticaly without using any shortkey or tab,

Please help.