Thread
:
Time Stamp
View Single Post
#
4
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
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.
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett