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

**thanhmasterip** · 08-19-2014, 12:00 AM

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.

**HaHoBe** · 08-19-2014, 12:07 AM

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

**thanhmasterip** · 08-19-2014, 12:28 AM

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.

**HaHoBe** · 08-19-2014, 10:41 AM

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

**thanhmasterip** · 08-20-2014, 01:20 AM

Got it. Thank you

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

LinkBack

Thread Tools

Rate This Thread

Display

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

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

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

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

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

Thread Information

Users Browsing this Thread

Similar Threads

Alter Worksheet Change Event at specific time after the data is manually changed..

Excel 2007 : Protecting cells so that fomula cannot be changed manually but can be using edit links

VBA error when values changed with form controls (scroll bar), fine manually entered.

Equal sign not allowing a Date

[SOLVED] Paste link versus allowing two cells equal each other?

Bookmarks

Bookmarks

Posting Permissions