Workbook does not work in excel 2007, but is fine in 2010

[cath1509]

Hi all,

I have finished developing this spreadsheet for my company (or so I thought) and when i rolled it out, it kept asking people with excel 2007 to debug the code when the second userform was opened (it is attached and the code for the second userform is below). There is nothing wrong with it on excel 2010. I think that it is something to do with the listbox... but anywho, any help would please be appreciated!!

Please Login or Register  to view this content.

[cath1509]

If it helps anybody I've managed to find out it is this line of code:

Please Login or Register  to view this content.

That is the issue... apparently 2007 doesn't like arrays and autofilters mixed together

[Norie]

Why are you using an array for the criteria?

Wouldn't it make more sense to use 2 criteria to specify the date range?

Something like this, >=Date()-7 and <=Date().

Not sure what the code for that would be but you should get something to work with if you turn on the macro recorder when you do the filter manually.

[cath1509]

Fantastic, recorded the macro and have managed to get the criteria code!

Btw, thank you so much for all your help recently, I've learnt so much in the last few weeks!