+ Reply to Thread
Results 1 to 8 of 8

VPA delete entire row if condition met & move upxit from macro

  1. #1
    Registered User
    Join Date
    07-02-2012
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    15

    VPA delete entire row if condition met & move upxit from macro

    Worked beautifully thank you JB.
    Related Q: Delete entire row if condition is met, as per attached. If you can help with corrections much appreciated.
    Sorry, I am struggling a bit but keen to learn and be competent. Thank you, regards.
    Attached Files Attached Files
    Last edited by Alfie101; 07-03-2012 at 08:56 AM.

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: VPA conditional exit from macro

    That's a fairly simple oneliner:

    Please Login or Register  to view this content.

    or:

    Please Login or Register  to view this content.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Registered User
    Join Date
    07-02-2012
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    15

    Re: VPA delete entire row if condition met & move upxit from macro

    Ok, i think i have this out of order - sorry. Have just replied, thanked and posted a related question. Alfie

  4. #4
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: VPA delete entire row if condition met & move upxit from macro

    I don't understand what you're saying. If there is a related post somewhere please provide a link to it.

  5. #5
    Registered User
    Join Date
    07-02-2012
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    15

    Re: VPA delete entire row if condition met & move upxit from macro

    Very simple but I am grappling.
    I have numbers in a column (G1:G20). I want to find if any any are >12.0 and if so delete that entire row, and have the other rows move up to replace deleted rows.
    Sorry about clarity before, many thanks. Alfie

  6. #6
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: VPA delete entire row if condition met & move upxit from macro

    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    07-02-2012
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    15

    Re: VPA delete entire row if condition met & move upxit from macro

    Just great JB. Much appreciated thank you. Alfie101

  8. #8
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: VPA delete entire row if condition met & move upxit from macro

    If that takes care of your need, please select Thread Tools from menu above and set this topic to SOLVED.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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