Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The extract below is unable to run when the criteria for the
Autofilter results in the number of rows being in excess of around 15800. Selection.AutoFilter Field:=6, Criteria1:="=" Range("A2").Select Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select Selection.SpecialCells(xlCellTypeVisible).Select Selection.EntireRow.Delete Even when attempted manually, the "delete rows" function will not work on a filter and deletes ALL data (both hidden and otherwise). Hence my subject, the macro won't delete only rows for filtered results where the filter produces too many rows. I hope I've made myself understood. Is there a workaround? Cheers |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
COPY PASTE with FILTER copies anti-filtered results as hidden rows | Excel Programming | |||
Delete all filtered rows from a macro? | Excel Programming | |||
cannot delete filtered rows in excel 2007 | Excel Discussion (Misc queries) | |||
Cut filtered rows, paste into next empty row of new sheet, and delete cut rows | Excel Worksheet Functions | |||
Excel - How do I delete filtered out rows? | Excel Discussion (Misc queries) |