+ Reply to Thread
Results 1 to 3 of 3

Delete Data Based On Cell Value

  1. 07-07-2020, 11:35 AM #1
    terratushi
    terratushi is offline
    Registered User
    Join Date
    08-16-2016
    Location
    London, England
    MS-Off Ver
    2013
    Posts
    88

    Delete Data Based On Cell Value

    Hi,

    I have some code which checks a cell value and deletes the entire row

    Please Login or Register  to view this content.

    Is it possible to amend the code so instead of deleting the entire row it only deleted columns A:K, I would also need the delete to "shift cells upwards"

    Any help would be great,

    Thanks
    Reply With QuoteRegister To Reply
  2. 07-07-2020, 11:41 AM #2
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,503

    Re: Delete Data Based On Cell Value

    Maybe change 
    Please Login or Register  to view this content.
    to 
    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  3. 07-07-2020, 11:41 AM #3
    Mumps1
    Mumps1 is offline
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 365
    Posts
    8,050

    Re: Delete Data Based On Cell Value

    Try:
    Please Login or Register  to view this content.
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.
    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. Generate or delete column of data based on cell value
    By JeroenCarlos in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-15-2019, 06:47 AM
  2. Generate or delete column of data based on cell value
    By JeroenCarlos in forum Excel General
    Replies: 1
    Last Post: 04-15-2019, 06:47 AM
  3. [SOLVED] Delete specific range cell data based on user input
    By terriertrip in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 07-06-2017, 07:57 PM
  4. [SOLVED] delete cell data based off expired date
    By Loadtoad in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-19-2014, 11:35 PM
  5. Delete row based on cell FORMAT (color, font, etc) (not based on cell value)
    By trobey in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-12-2012, 10:39 AM
  6. How to delete rows of data based on cell values in VB?
    By drx in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-24-2011, 04:45 PM
  7. Delete multiple rows of data based on criteria in a single cell
    By slaga9 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-12-2011, 03:41 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