Autofilter generates #REF! when run but works correctly when stepped through

When I allow the following autofilter to simply run it does not copy the data over, but if i place a breakpoint on the autofilter and then step through the code it works fine.

Please Login or Register  to view this content.

Anyone know why i am running into this problem?

Edit: Hold off working this please - I believe the problem is actually being caused by some cells just under the range copied over having calculations in them. When i run the code over, those cells do not get deleted and this is when the problem occurs. I am going to try making certain everything in the target copy area is blown away and then re-run the code. Will advise...

Edit: That was it. As they say; "My bad"...