I don't have an idea.

But I'd step through the macro using the F8 key and between every major
(whatever that means), I'd swap back to excel to see if things look like they
should.

Mustang wrote:

Hi,

I have recorded a macro that uses the advanced filter to give me all work
that was carried out between two dates.

This data is copied to a new sheet.

There is a third sheet which contains a pivot table to analyse this data.

This was working perfectly when I had test data in, now that we are
inputting real data with different dates to my test it is failing.

I am running the macro from a button.

If I go through the exact steps of the macro it works, so I re-record it and
it fails to work.

Any ideas why?

Thanks

--

Dave Peterson