Loop Copying Problems

**wesbuckley** · 05-07-2009, 06:07 PM

Hi, i've wrote a code with loops to try and copy data between 2 times.
here it is

Please Login or Register  to view this content.

Now my first Problem is that for the if statment with the and i cannot get the <= and >= to work properly is i use as is written in the code at the moment then it only give me a couple of value out of 10 even though they are all between the dates, also is i change it so they both are >= then it gives me every value but the first one. Can anyone tell me where i'm going wrong.
Thanks for all the help

**shg** · 05-07-2009, 06:14 PM

Welcome to the forum, Wes.

We're looking at code that doesn't work, and trying to imagine the workbook that goes with it. That's a tough combination.

**wesbuckley** · 05-07-2009, 06:18 PM

haha ok i get your point, hope thats a bit better.
sorry

**wesbuckley** · 05-07-2009, 06:54 PM

I've fixed the problem now, i realised that the 2 times i was using were in different formats, one did not have the seconds added to them, so after adding this it gave me the correct values. Also to solve the problem of it not including the 1st value i did all of the data, then at the end i put the title to the columns at the end.

Please Login or Register  to view this content.

And also i will include the final piece of the weather system that records data and now will show data between 2 dates on a graph, all from the forms menu.

**shg** · 05-07-2009, 07:17 PM

I remember this workbook.

Format all the cells that are supposed to be dates as General. If they don't turn into numbers, they're stored as text, which means code isn't going to work. You need to fix that first.