+ Reply to Thread
Results 1 to 5 of 5

Set 2 cells equal, while allowing either one to be manually changed

  1. #1
    Registered User
    Join Date
    08-18-2014
    Location
    USA
    MS-Off Ver
    2013
    Posts
    3

    Set 2 cells equal, while allowing either one to be manually changed

    I'm using Excel 2013 and running this VBA code:

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    I got this error when I input the data in the cell:
    Run-time error '-2147417848 (80010108)
    Method 'Value' of object 'Range' failed.

    Please help. Thank you.

  2. #2
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    2013 on Win10 (desktop), 2007 on Win10 (notebook)
    Posts
    7,992

    Re: Set 2 cells equal, while allowing either one to be manually changed

    Hi, thanhmasterip,

    turn off the events to get fired on a change in any of the cells mentioned?

    Behind Sheet1:
    Please Login or Register  to view this content.
    Behind Sheet2:
    Please Login or Register  to view this content.
    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  3. #3
    Registered User
    Join Date
    08-18-2014
    Location
    USA
    MS-Off Ver
    2013
    Posts
    3

    Re: Set 2 cells equal, while allowing either one to be manually changed

    Thank you for the quick answer. It works perfectly when I opened a new Excel file but when I applied it to my model. I got this error instead: "run-time error '9': Subscript out of range" . Below is the code I used:

    Sheet 13:
    Please Login or Register  to view this content.
    Sheet 16:
    Please Login or Register  to view this content.
    Debug points toward this line in sheet 16:
    Please Login or Register  to view this content.

  4. #4
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    2013 on Win10 (desktop), 2007 on Win10 (notebook)
    Posts
    7,992

    Re: Set 2 cells equal, while allowing either one to be manually changed

    Hi, thanhmasterip,

    Please Login or Register  to view this content.
    is looking for a sheet with the worksheet tab being named Sheet16, and I pretty much doubt that your sheets are named like that. The sheets you want to rely on simply canīt be fiound in the workbook.

    If you would like to use the codename try
    Please Login or Register  to view this content.
    where Sheet16 is the codename displayed in the project explorer/property window.

    Ciao,
    Holger

  5. #5
    Registered User
    Join Date
    08-18-2014
    Location
    USA
    MS-Off Ver
    2013
    Posts
    3

    Re: Set 2 cells equal, while allowing either one to be manually changed

    Got it. Thank you

+ 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. Alter Worksheet Change Event at specific time after the data is manually changed..
    By e4excel in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-22-2014, 05:12 PM
  2. Replies: 0
    Last Post: 06-04-2012, 07:21 AM
  3. Replies: 0
    Last Post: 12-13-2011, 05:13 PM
  4. Equal sign not allowing a Date
    By skhammonds in forum Excel General
    Replies: 2
    Last Post: 11-14-2007, 07:48 PM
  5. Replies: 5
    Last Post: 01-04-2005, 01:06 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