+ Reply to Thread
Results 1 to 3 of 3

Delete Row if Colunm has any text or Numbers

  1. 05-07-2016, 12:03 PM #1
    plank22
    plank22 is offline
    Registered User
    Join Date
    01-01-2014
    Location
    United States
    MS-Off Ver
    O365 (v2204)
    Posts
    82

    Delete Row if Colunm has any text or Numbers

    I am looking for a way to delete entire rows if column H has any value.

    missing upc h.JPG
    Reply With QuoteRegister To Reply
  2. 05-07-2016, 12:08 PM #2
    sourabhg98
    sourabhg98 is offline
    Forum Expert sourabhg98's Avatar
    Join Date
    10-22-2014
    Location
    New Delhi, India
    MS-Off Ver
    Excel 2007, 2013
    Posts
    1,899

    Re: Delete Row if Colunm has any text or Numbers

    Try this macro-
    Please Login or Register  to view this content.
    Note-
    1. Last row is determined by the last non-blank cell in Column A (can be changed)
    2. Macro begins from the 3rd row (can be changed)
    Happy to Help

    How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html

    "I don't get things easily, so please be precise and elaborate"

    If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
    If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.

    Sourabh
    Reply With QuoteRegister To Reply
  3. 05-07-2016, 03:24 PM #3
    jaslake
    jaslake is offline
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Delete Row if Colunm has any text or Numbers

    Hi plank22

    How about Auto Filter on Column H for non-blank cells...delete the Visible Rows...remove Auto Filter?
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Macro to delete duplicate cell only not entire row if some data is duplicated in colunm
    By petitesouris in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-29-2014, 03:23 AM
  2. [SOLVED] Delete text, split numbers to two cells and store as numbers
    By Steve_123 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-10-2014, 09:51 AM
  3. [SOLVED] Delete numbers and keep text
    By Ucpaul in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-13-2013, 02:02 PM
  4. delete text, keep numbers
    By Annelie in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-16-2010, 11:03 AM
  5. Possible sum in colunm of numbers
    By Pedroluna in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-13-2009, 02:44 PM
  6. [SOLVED] Delete text while numbers remain intact
    By Sugar_grrl in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 04:05 PM
  7. Delete text while numbers remain intact
    By Sugar_grrl in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1