ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Is there an Excel 2003 Advanced Filter Bug?! (https://www.excelbanter.com/excel-discussion-misc-queries/145748-there-excel-2003-advanced-filter-bug.html)

danielnickless

Is there an Excel 2003 Advanced Filter Bug?!
 
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


All times are GMT +1. The time now is 01:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com