+ Reply to Thread
Results 1 to 2 of 2

Program execution hangs on deleting rows shown in an AutoFilter

  1. #1
    Forum Contributor
    Join Date
    12-15-2009
    Location
    Herndon, VA
    MS-Off Ver
    Excel 2010
    Posts
    163

    Program execution hangs on deleting rows shown in an AutoFilter

    A part of my code involves using an AutoFilter to pull up rows that need to be deleted. The criteria is 'ZZZ.' After filtering for 'ZZZ' I want to select all the rows and delete them.


    Please Login or Register  to view this content.
    I did a step into with breakpoints and I determined that the execution on the line above is where the program hangs. I say hangs, because when I first coded this, I didn't have this problem. What could be causing this? This is frustrating because I know my program can run faster.

  2. #2
    Forum Expert
    Join Date
    02-22-2013
    Location
    London, UK
    MS-Off Ver
    Office 365
    Posts
    1,218

    Re: Program execution hangs on deleting rows shown in an AutoFilter

    With autofilter, you want to delete all the visible rows which you can do by using Specialcells. Here is an example, with the column A with the autofilter (starting from A2):

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Autofilter with dates instead of deleting rows
    By johnny_p in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-21-2013, 11:20 AM
  2. deleting rows of data using autofilter macro
    By tedingham in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-25-2012, 10:49 AM
  3. Macro program to autofilter and delete specific rows with conditions
    By MAKRUMAHESH in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-20-2012, 09:05 PM
  4. After autofilter, Excel is deleting even the hidden rows!
    By JKurz2008 in forum Excel General
    Replies: 4
    Last Post: 11-13-2009, 02:23 AM
  5. [SOLVED] How to I program on rows after autofilter in Excel?
    By Jacky in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-10-2005, 03:08 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1