+ Reply to Thread
Results 1 to 5 of 5

Macro to delete specific range in a row with condition

  1. #1
    Registered User
    Join Date
    01-24-2013
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    7

    Macro to delete specific range in a row with condition

    Hi all,
    I am looking for a macro which can delete a particular range depending upon a specific cell criteria:
    Eg: Data is present in cells C to Z; If C=0; shift cells up (not entire row deletion) from C to Z.

    Thanks in advance.

    P.S. Apologies if I have opened a new thread, couldn't find a relevant one while search!

  2. #2
    Valued Forum Contributor
    Join Date
    02-09-2012
    Location
    Mauritius
    MS-Off Ver
    Excel 2007
    Posts
    1,055

    Re: Macro to delete specific range in a row with condition

    Hi.

    Try this:

    Please Login or Register  to view this content.
    Click *, if my suggestion helps you. Have a good day!!

  3. #3
    Registered User
    Join Date
    01-24-2013
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Macro to delete specific range in a row with condition

    Hi
    The code works flawlessly. Thanks a ton!! However, I would like to add one more condition that C = 0 or blank, shift cells up from C to Z.

  4. #4
    Valued Forum Contributor
    Join Date
    02-09-2012
    Location
    Mauritius
    MS-Off Ver
    Excel 2007
    Posts
    1,055

    Re: Macro to delete specific range in a row with condition

    check this modified code:

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    01-24-2013
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Macro to delete specific range in a row with condition

    Thanks again jraj1106, it works!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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