+ Reply to Thread
Results 1 to 6 of 6

amalgamate 2 worksheet change vba scripts

  1. #1
    Registered User
    Join Date
    02-09-2012
    Location
    UK
    MS-Off Ver
    Excel 2010
    Posts
    31

    amalgamate 2 worksheet change vba scripts

    I need help amalgamating these 2 worksheet change vba script. 'ambiguous name detected worksheet_change' error.
    Here's my code:

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,420

    Re: amalgamate 2 worksheet change vba scripts

    Try:

    Please Login or Register  to view this content.

    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    02-09-2012
    Location
    UK
    MS-Off Ver
    Excel 2010
    Posts
    31

    Re: amalgamate 2 worksheet change vba scripts

    Thanks for the relpy. I get an 'application-defined or object-defined error'

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,420

    Re: amalgamate 2 worksheet change vba scripts

    Not sure why that would be. I have just combined the code lines into one routine. If it worked before, I can' twee why it shouldn't execute as one routine.

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,420

    Re: amalgamate 2 worksheet change vba scripts

    Wonder what you did to get that error?

    Please Login or Register  to view this content.

    See attached sample workbook.

    Regards, TMS
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    02-09-2012
    Location
    UK
    MS-Off Ver
    Excel 2010
    Posts
    31

    Re: amalgamate 2 worksheet change vba scripts

    Works perfectly!!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Amalgamate 30 or so worksheets with same heading
    By ashpool in forum Excel General
    Replies: 2
    Last Post: 10-29-2012, 11:31 AM
  2. Running Two Worksheet Change Scripts Gives Error
    By BazzaBoy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-12-2009, 04:24 AM
  3. For a website, are Excel scripts better than other programming language scripts?
    By Advice Pro in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-01-2009, 02:07 PM
  4. Amalgamate 2 files
    By jwoodlor in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-07-2008, 07:14 AM
  5. [SOLVED] How do I amalgamate worksheets
    By Julia Underwood in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-24-2005, 02:06 PM

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