+ Reply to Thread
Results 1 to 3 of 3

Worksheet_Change event - second part not working since Target is already being defined

  1. #1
    Registered User
    Join Date
    01-14-2015
    Location
    USA
    MS-Off Ver
    2010
    Posts
    2

    Worksheet_Change event - second part not working since Target is already being defined

    This is my first post so please forgive me if I am not clear. Below is my code, it works up to the 'The following code isn't working anymore. If I delete the part above that line then it works, but it appears there are issues since "Target" is already used above. Ideally I would like to have two Private Sub Worksheet_Change events, but I know that's not allowed in Excel, so I am stuck. This is used on a sheet that is being copied multiple times so there will be multiple tabs with this code that need to work independently of each other. Any advice would help

    Please Login or Register  to view this content.

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Worksheet_Change event - second part not working since Target is already being defined

    Not relly sure what the data your code is working on actually looks like, however ...

    Could you take a copy of Target as another range variable at the top or the code and use this in the lower portion of the code?
    Martin

  3. #3
    Registered User
    Join Date
    01-14-2015
    Location
    USA
    MS-Off Ver
    2010
    Posts
    2

    Re: Worksheet_Change event - second part not working since Target is already being defined

    I realized I just needed to take the "Else: Exit Sub" out and it worked. Thanks though!

+ 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. Replies: 5
    Last Post: 12-16-2014, 05:47 PM
  2. Private Sub Worksheet_Change(ByVal Target As Range) not working
    By kaseyleigh in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-05-2013, 07:12 AM
  3. [SOLVED] Worksheet_Change Event - Target.Name.Name error in certain situations
    By GazP in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-18-2013, 04:14 AM
  4. capture the name of the target passed into Worksheet_Change event
    By Isabel Lopatin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-22-2013, 01:06 AM
  5. Worksheet_Change event not working on xl2003
    By matrex in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-29-2008, 12:38 PM

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