+ Reply to Thread
Results 1 to 16 of 16

Delete row if cell contains the word "Warning"

Hybrid View

  1. 01-12-2017, 05:17 PM #1
    CC268
    CC268 is offline
    Registered User
    Join Date
    03-01-2016
    Location
    Phoenix, AZ
    MS-Off Ver
    MS Office 2013
    Posts
    94

    Re: Delete row if cell contains the word "Warning"

    Hmm...ran it twice...still nothing. If it matters the Warning message is in a merged cell...but I don't think that should matter.
    Last edited by jeffreybrown; 01-12-2017 at 05:48 PM. Reason: As per Forum Rule #12, please don't quote whole post unless necessary -- it's just clutter.
    Reply With QuoteRegister To Reply
  2. 01-12-2017, 05:21 PM #2
    davesexcel
    davesexcel is offline
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,526

    Re: Delete row if cell contains the word "Warning"

    You may have to supply a sample.
    ,
    Xlorate.com, Selection Codes, YouYube Channel
    Reply With QuoteRegister To Reply
  3. 01-12-2017, 05:33 PM #3
    CC268
    CC268 is offline
    Registered User
    Join Date
    03-01-2016
    Location
    Phoenix, AZ
    MS-Off Ver
    MS Office 2013
    Posts
    94

    Re: Delete row if cell contains the word "Warning"

    Quote Originally Posted by davesexcel View Post
    You may have to supply a sample.
    Alright I attached the sheet...I deleted all the data but at least you can see the layout and where the Warning message is (all the way at the bottom). I know it probably just makes sense to scroll to the bottom and delete it manually, but if I can automate it that would be nice as I am doing a lot of other VBA on this sheet.
    Attached Files Attached Files
    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] Delete a cell and shift left if it contains the word "school"
    By clundqui in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 09-08-2016, 03:27 PM
  2. [SOLVED] Need to Find All Cells Containing "Word" and Replace With "Other Word" from Cell Below?
    By notsmart in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-05-2016, 09:00 AM
  3. [SOLVED] IF statement to return value when cell contains a specific word finding "1" for "10"
    By arisphaedrus in forum Excel General
    Replies: 12
    Last Post: 06-12-2014, 02:11 PM
  4. [SOLVED] Formula Needed to fill multiple cells with "No" when the word "No" is entered into a cell
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-09-2013, 05:36 PM
  5. [SOLVED] Macro to delete entire row if cell contains the word "total" or "Total"
    By theatricalveggie in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-10-2011, 12:38 PM
  6. How to filter for word in text cell? ie "mental" not "environmental"
    By duff in forum Excel General
    Replies: 2
    Last Post: 08-02-2011, 06:57 AM
  7. [SOLVED] possible? =if(That cell = "a certain word", delete row, go next)
    By Jim in forum Excel General
    Replies: 2
    Last Post: 02-27-2006, 04:45 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1