+ Reply to Thread
Results 1 to 6 of 6

Partial Row Deletion

  1. #1
    Registered User
    Join Date
    04-03-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    15

    Unhappy Partial Row Deletion

    I am hoping someone can help me with this macro, I need a macro that from the active cell skips over 10 other cells in the same row then deletes everything else in that row including form controls and data validation. I would very much appreciate help cause my last several attempts have ended in epic failures

  2. #2
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Partial Row Deletion

    Maybe:

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    04-03-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    15

    Re: Partial Row Deletion

    That is fantastic and thank you so much but its is still not deleting the form controls (buttons) and data validations I tried to replace .Clear with .ClearFormat and .Delete but with delete it seems to delete the row but then move the rest of the cells underneath up one row.

  4. #4
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Partial Row Deletion

    Try:

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    04-03-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    15

    Re: Partial Row Deletion

    Thanks so much John you are a Legend. You made my day

  6. #6
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Partial Row Deletion

    You're welcome. Glad to help out and thanks for the feedback. Please comply with Forum Rule No. 9.

    9. Acknowledge the responses you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Dropdown option or Edit button will not appear -- ask a moderator to mark it.

+ 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. [SOLVED] Match partial text when partial text is not exact
    By NamiSama in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 05-21-2014, 07:18 PM
  2. Prevent workbook deletion or create the copy upon the deletion?
    By ciapul12 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-29-2014, 04:35 PM
  3. [SOLVED] need to do Partial name search and return the value against the partial name
    By Kiran Kurapati in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-09-2013, 09:40 AM
  4. Replies: 16
    Last Post: 04-20-2010, 01:27 PM
  5. matching partial text within one cell to partial text within another
    By Solstice in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 03-03-2010, 09:13 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