If I do

Range ("a1") = timer

on a loop then it refreshes showing fractions of a second, but shows
whatever large number the timer is at


However if i do


tim = Timer
Do

diff = Timer - tim
Range("a1") = diff

loop

then it counts up from zero, as intended, but for some reason drops all the
decimal places

Anyone know why it drops the decimals and how to make it keep the decimals?

Many thanks

tim = Timer
Range("a1").NumberFormat = "0.0"
Do
diff = Timer - tim
Range("a1") = diff
Loop


--
mikeaj72
------------------------------------------------------------------------
mikeaj72's Profile: http://www.thecodecage.com/forumz/member.php?userid=46
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=44335

tim and diff need to be declared as Single or Double.
Integer and Long carry no decimal places.
--
Jim Cone
Portland, Oregon USA



"teepee"
wrote in message
If I do
Range ("a1") = timer

on a loop then it refreshes showing fractions of a second, but shows
whatever large number the timer is at
However if i do
tim = Timer
Do
diff = Timer - tim
Range("a1") = diff
loop

then it counts up from zero, as intended, but for some reason drops all the
decimal places
Anyone know why it drops the decimals and how to make it keep the decimals?
Many thanks

Thanks for the help