Excel linking cells

[Hidden999]

Hi guys,

I am making a worksheet and have a question regarding linking cells.

What I want to achieve:
Having two cells (on different sheets or not) which contain the same text.
So if I change the text in one cell it also changes in the other cell. Vice versa.
I've tried doing it just like this.

A1 contains formula (=B1)
B1 contains formula (=A1)

But then if you type it overwrites the formula.

Thanks in advance!

 

[Fluff]

To jsut have it work on A1 change

If Target.Column = 1 Then

to

If Target.Address(0,0)= "A1" Then

 

[Hidden999]

Again thanks for your help. Still my question: what if I want a row or just one certain cell? In what way does the code change?

 

[Fluff]

I showed you how to do it for one certain cell, to use row1 rather than column 1 just change .Column to .Row

 

[Hidden999]

Thanks again mate. It doesnt work though. It says that the line with (Sheets ... Target.Value) doesnt work?!

 

[Fluff]

What was the exact error message?
Was in Run time error 9 subscript out of range?

 

[Hidden999]

That was it yeah

 

[Fluff]

In that case you didn't change the values in red to your actual sheet names.

 

[Hidden999]

Still doesn't work. It either gives an error and doesnt work or does nothing and doesnt work. I've a 100% changed the names correctly?!

 

[Fluff]

What is the error message?

 

[Hidden999]

The error you named before. What I do is add the code to the worksheet and then change the red name into the name of the other worksheet. Then I save and a message pops up saying you're saving without marcros or something. Does it work for you then?