hi, hope I can ask this clearly.
a                  b    c    d    e       f         g         h                   i     j
k    l
09/10/2004    14    11    18    Walsall    2           1      Colchester     9    4    3

Im using data laid out as above running from january to December. I
take the data from the worksheet put into a dynamic array, comapre f to
h if the same I then put that data for the row into another array and
paste back to worksheet. That side of I can do fine. But a big
difficulty Icant seem to resolve is that with dates 10/10/2001 -
31/10/2001 & 13/11/2004 - 30/11/2004 & 10/12/2004 - 29/12/2004, when My
program runs on auto from jan to dec these dates dont capture f & g
data. They capture everything else, a,b,c,d,e,g(a space),i,j,k,l. All
the other dates are perfect. Now the strange thing is if I step through
the program (f8), its fine. Whence I cant find the problem. I am using
variables, so I wondering if I should be emptying these after each pass
through. Basically the program takes the first date, if it meets a
criteria, goes of and to another worksheet enters some details, comes
back to original, enters data into array then paste to sheet, emptys
aray and moves to next date. any advice appreciated.
Regards Robert