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: 989
Default Select non-consecutive cells for deletion

I am trying to filter a large range of cells in a column for several
different values. If the values exist, the entire row should be deleted.
The problem is, across many cells in the range, if each cells is evaluated
and deleted one by one, the process can be very slow. I want to figure a way
to some how select or store all the cells in the range first and then delete
them in one go. How/is this possible? (Note: Since there are a number of
values that trigger the deletion, I don't think autofiltering is an option)
 
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
Deletion Of Cells DDD Excel Worksheet Functions 1 December 10th 08 01:19 AM
Auto Deletion of 4 consecutive rows out of every 5 scratching my head Excel Programming 1 June 1st 05 02:14 PM
Auto Deletion of 4 consecutive rows out of every 5 filo666 Excel Programming 0 May 31st 05 11:40 PM
Select non-consecutive rows dee Excel Discussion (Misc queries) 14 December 4th 04 08:45 PM
Select two consecutive rows Bruce Roberson Excel Programming 8 July 31st 03 03:06 PM


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

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

About Us

"It's about Microsoft Excel"