Thread: Time Stamp
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Time Stamp


use a regular sub to click on
sub datestamp()
activecell=date
'or
'range("a2")=date
end sub


--
Don Guillett
SalesAid Software

"DAI" <u29573@uwe wrote in message news:69d229a7b7d62@uwe...
Hello,

I have created a macro to give me start and finish times with the click of
a
button,

Function my_now()
Application.Volatile (False)
my_now = Now
End Function

However every now and the all entries are recalculated. (It only happens
when
im not looking)

I was under the impression that with the (Application.Volatile (False))
this
could not happen.

Any ideas would be welcome.