Cell change affects another sheet

So what's your question?

Sorry, its not working for me.

Are you getting an error or does just nothing happen?

Try this instead, there's all kinds of unnecessary cr*p in the original.

Please Login or Register  to view this content.

If it still doesn't work then I'll need to know the error message. If nothing happens at all then you've got events turned off. Open the immediate window in the VBA editor and type

Please Login or Register  to view this content.

and then try it again.

That works perfectly, thank you. The error i was getting was select method of range class failed.