+ Reply to Thread
Results 1 to 2 of 2

macro to clear contents of two ranges if cell is blank

  1. #1
    Registered User
    Join Date
    04-03-2011
    Location
    OR
    MS-Off Ver
    Excel 2010
    Posts
    2

    macro to clear contents of two ranges if cell is blank

    I'd like to have a macro that would look in column AOT (beginning at row 5), and for whatever cell in this column is blank, the ranges of AJI:AOJ and AOO:AOS for that particular row would have their contents cleared.

    For example, if AOT5 is blank, then AJI5:AOJ5 and AOO5:AOS5 would have their contents cleared. And this would happen down to row 500.

    Any help would be greatly appreciated!

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: macro to clear contents of two ranges if cell is blank

    Hello fisher-price,

    Welcome to the Forum!

    This macro checks the cells in the range "AOT5:AOT500". If any cell is blank, it will clear cells "AJIx:AOJx" and "AOOx:AOSx" in row x where x is the row of the cell that is blank.
    Please Login or Register  to view this content.

    Adding the Macro (Excel 95 - 2003)
    1. Copy the macro above pressing the keys CTRL+C
    2. Open your workbook
    3. Press the keys ALT+F11 to open the Visual Basic Editor
    4. Press the keys ALT+I to activate the Insert menu
    5. Press M to insert a Standard Module
    6. Paste the code by pressing the keys CTRL+V
    7. Make any custom changes to the macro if needed at this time.
    8. Save the Macro by pressing the keys CTRL+S
    9. Press the keys ALT+Q to exit the Editor, and return to Excel.

    To Run the Macro...
    To run the macro from Excel, open the workbook, and press ALT+F8 to display the Run Macro Dialog. Double Click

    the macro's name to Run it.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

+ 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