Cells keep reverting from "General" to "Text"

[Djarn]

I am currently using the following formula on sheet1

Please Login or Register  to view this content.

At first it all works, but then when I edit a cell in a different column range, somehow the formatting in Column B changes to text, when I manually changed it to General.

What I do after is highlight B7:B300, change cell formatting to General again, and delete contents, then the VBScript puts everything back as it should be, so B7 for example will reflect the value of B7 on Sheet2, however, I'll edit cell in a range again, one that doesn't even effect column B or any other cells that affect column B, and all my cells in B will change from general to Text. so Ill get something like =Sheet2!B7 , and it'll actually show this to the person viewing the document in all cells in column B , as well as in the formula bar.

How do I stop this from happening?

[romperstomper]

Do you really want this code running when you make any change at all to the worksheet?