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.
Thankyou in advance for any help.
Bookmarks