delete rows from an Advanced Filter range

Gareth

Guest

Posts: n/a

6th Jan 2009

I have a sheet of approx 20,000 rows. I have had to use Advanced Filter to
pick out rows that I want to delete but I am now stuck.
Would somebody be able to help me with some code to delete the rows (if
there are any)?

Thanks in advance.

Gareth

« Code to copy and paste those cells that have data | RE: Change order of data in a cell »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
delete rows from AutoFilter or Advanced Filter range	Gareth	Microsoft Excel Programming	1	7th Jan 2009 01:01 PM
RE: delete rows from an Advanced Filter range	Mayte	Microsoft Excel Programming	0	6th Jan 2009 09:59 PM
Help with filter Range & delete rows	Les	Microsoft Excel Programming	2	19th Oct 2006 07:33 AM
Auto Filter Delete Rows by Criteria Doesn't Work Range To Complicated	robertjtucker	Microsoft Excel Programming	1	29th Sep 2005 05:47 PM
advanced filter a range	=?Utf-8?B?SWwgUHJpbmNpcGU=?=	Microsoft Excel Worksheet Functions	2	1st Aug 2005 03:27 PM