+ Reply to Thread
Results 1 to 3 of 3

Delete entire row if criteria cell is blank

  1. #1
    Registered User
    Join Date
    04-12-2007
    Posts
    57

    Delete entire row if criteria cell is blank

    I am having trouble with this one. I am trying to write a macro to delete the entire row if the cell located in column AK of that row is blank. The column is text formated. The only text that will ever be in this column is HNFD. I have tried putting that in with <>, but it didn't work for me.
    HTML Code: 

  2. #2
    Forum Expert
    Join Date
    01-12-2007
    Location
    New Jersey
    Posts
    2,127
    I have never done the autofilter approach. You can use a loop to delete blanks.

    Please Login or Register  to view this content.
    Let me know if you can work with that.

  3. #3
    Registered User
    Join Date
    04-12-2007
    Posts
    57
    Worked simply marvelous. Thanks so much.

+ 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. read cell content and use with Hyperlinks.Add Cell
    By apoc [t.i.m.] in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-04-2007, 10:02 AM
  2. Conditional Format- Blank cell with formula problem
    By Trappy in forum Excel General
    Replies: 4
    Last Post: 08-20-2007, 09:51 AM
  3. Replace Entire cell content
    By srinia123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-14-2007, 02:38 AM
  4. 0.00 showing in an empty cell, I want it blank
    By matt_the_brum in forum Excel General
    Replies: 2
    Last Post: 10-13-2006, 03:51 AM
  5. Find a value, delete cell and next cell
    By rbmcclen in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-12-2006, 01:25 PM

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