+ Reply to Thread
Results 1 to 3 of 3

Clear cells using a worksheet change event

  1. #1
    Registered User
    Join Date
    06-13-2011
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    24

    Clear cells using a worksheet change event

    Hello,

    Grateful for some help with this. Here's what I want to do in my spreadsheet:

    If the contents of column Q are changed (from row 12 downwards) or if the contents of column R are changed (from row 12 downwards), then I want to clear the contents of whatever is in columns U to AF for that/those row/rows.

    Thanks in advance,

    HE
    Last edited by headexperiment; 12-12-2011 at 07:26 AM.

  2. #2
    Forum Contributor wamp's Avatar
    Join Date
    11-10-2008
    Location
    Norway
    MS-Off Ver
    97, 2000 & 2003 (diff. workstations)
    Posts
    184

    Re: Clear cells using a worksheet change event

    Please Login or Register  to view this content.
    _______________________________________________
    Remember:

    Read the rules!

    Use code tags! Place [CODE] before the first line of code and [/CODE] after the last line of code.

    Mark your post [SOLVED] if it has been answered satisfactorily.
    To do this, click EDIT in your original post, click GO ADVANCED and set the PREFIX. It helps everybody!

    If you are approve (or disapprove) of any members response to your problem, please click the star icon underneath their post and comment. It matters.

  3. #3
    Registered User
    Join Date
    06-13-2011
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    24

    Re: Clear cells using a worksheet change event

    Quote Originally Posted by wamp View Post
    Please Login or Register  to view this content.
    Winner. Thanks

+ 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