Hiya,

I've been running a series of advanced filters in excel 2003 by vba macro.

It works fine in every case except when it trys to filter on the number
"260", in which case excel goes nuts.

All of the time the filter does not work, most of the time i recieve a
message saying there's a problem with the 'range' variable, and some of the
time it just quits excel and sends an error report to microsoft.

In addition to this, if excel doesn't crash, the cells do not highlight when
i try to move the cursor with the arrow keys (although the value in the
toolbar does change).

On odd occasions the spreadsheet has been randomly copied and pasted around.

Please help this is driving me nuts!!!!

Regards,

Dan