+ Reply to Thread
Results 1 to 5 of 5

How to combine two Worksheet_Change subs into one?

  1. #1
    Registered User
    Join Date
    12-06-2012
    Location
    mountain view, CA
    MS-Off Ver
    Excel 2010
    Posts
    4

    How to combine two Worksheet_Change subs into one?

    Hi everyone,

    I need help to combine the two following subs that work fine separately into one that works. Your help would be appreciated. Thanks!

    Please Login or Register  to view this content.
    Last edited by zozo23; 12-27-2012 at 12:36 PM.

  2. #2
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: How to combine two Worksheet_Change subs into one?

    Welcome to forum zozo23.

    Maybe you missed reading the rule about code tags? You must wrap all VBA code in code tags.

    Before receiving help, you need to edit your thread to add the missing tags. Just highlight all of the code, then click the button with the # symbol on it.
    Palmetto

    Do you know . . . ?

    You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.

  3. #3
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: How to combine two Worksheet_Change subs into one?

    Hi zozo23,

    Try this:

    Please Login or Register  to view this content.

    Sorry Palmetto - we must have posted simultaneously!
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  4. #4
    Registered User
    Join Date
    12-06-2012
    Location
    mountain view, CA
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: How to combine two Worksheet_Change subs into one?

    Palmetto, sorry for not following the code tags rule. Sort of new here but will think about it next time.

    xladept, your code works great. And I can understand it which is good Thanks for your time and help - really appreciated!

    Cheers.

  5. #5
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: How to combine two Worksheet_Change subs into one?

    zozo23,

    The Forum Moderators will require that you edit your post and add the codes. I suggest you take the time now to do so.

+ 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