Getting Worksheet_Change(Byval) to work with Worksheet_calculate on two different sheets?

Hi,

I have a sheet that needs to utilize the following code:

Please Login or Register  to view this content.

Then I have another sheet that is utilizing a code to transport values which is:

Please Login or Register  to view this content.

So, I can't transport values to the sheet that has the first code I wrote. I only get an error stating the following:

Run time error 9
Subscript out of range

The code that transfer values work perfectly on other sheets that does not utilize the calculation code.

Anyone know the solution to the problem?