LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 441
Default Bulk row deletion

Is there a way to use autofilter in code to show only certain rows with many
criteria?

For example, I need to display and delete only those rows conforming to all
of the following:

Column A: Cells like "###.###.####.######.###.##.###"
Columns C, D, E: Abs(C) + Abs(D) + Abs(E) = 0
Column F: < "U"

Once displayed, these rows will then be deleted. Your example code would be
most appreciated.

FYI: my original sheet contains 54,102 rows by 22 columns. About 29,000 rows
will be deleted. Thanks in advance.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Bulk Discount Formula dgold82 Excel Discussion (Misc queries) 4 June 20th 20 09:57 PM
Bulk vlookup? Sarah Excel Worksheet Functions 2 January 24th 07 08:12 PM
Removing hyperlinks in bulk i-Zapp Excel Discussion (Misc queries) 1 October 26th 05 11:21 AM
Removing hyperlinks in bulk Elkar Excel Discussion (Misc queries) 1 October 26th 05 11:20 AM
Bulk Email Don Kline[_3_] Excel Programming 1 August 31st 03 04:27 PM


All times are GMT +1. The time now is 05:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"