Problem with midnight date change using VBA macro for adding missing dates

Hello,

I have been using the code from this thread:

http://www.excelforum.com/excel-prog...and-times.html

It works very well, except that it does not change the date when crossing midnight. i.e. It will go 30/10/12 23:00 then 30/10/12 00:00 then 31/10/12 01:00. Of course, this means that the matching formula does not place the data in the correct place. When I type the formula directly into cells, it works perfectly and changes the date in the expected place. So it is something that the procedure is doing in VBA that stops this from working correctly and I can't for the life of me figure out what, which implies it is something very simple (usually the case!)

I think it is something to do with formatting, as I have added in some formatting otherwise it always returns no data. The code is below.

Please Login or Register  to view this content.

Thankyou in advance for any help.

After further investigation the problem appears to be with the .Value = .Value. For some unknown reason....