View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default VBA Dates & Cell Dates

On Tue, 15 Jul 2008 06:53:02 -0700, Graham Y
wrote:

Thanks Ron
I think this is actually a rounding or conversion issue somewhere in the
process, as when I initialize the 'total' variables to 1 second and then
subtract 1 second at the end of the loop, my totals all match. ( I have a
'grand' total and three 'section' totals, which were not matching, hence
finding the bug.)


I don't understand what you've written. But the one day difference between VBA
and Excel disappears on 1 Mar 1900. Since I don't really know how you are
attacking your problem, I'm afraid that's all I can give you. Hopefully you'll
be able to get things working to your satisfaction.

Best,
--ron