ExcelBanter - Excel 2003; spreadsheet with filtering; deleting rows

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Excel 2003; spreadsheet with filtering; deleting rows (https://www.excelbanter.com/excel-worksheet-functions/108659-excel-2003%3B-spreadsheet-filtering%3B-deleting-rows.html)

MHcoTech

Excel 2003; spreadsheet with filtering; deleting rows

Have a spreadsheet with 10k rows; filtering is on to identify duplicates; if
then stmt to id the duplicates; when I hilite to delete the selected rows
(roughly 3K at a time); it takes 4x as long as when we performed in a Excel
2002 on a Windows 2000 o/s.... Thoughts on the problem? OS is upgraded to a
WinXP pro latest sp
--
Thanks!
PSmith

All times are GMT +1. The time now is 08:50 PM.