Circular reference

[hollanu]

Hi,
I have been working on a program for a few months now and finally have finished it. Everything was working the way I want (I purposely introduced a circular reference to convert back and forth from mm to in, see code below). I was recently moved at work and am now using a different computer, but does use the same version of excel. Now, all of my cells contain the infamous "#NAME?". Excel made me aware on both machines that there were circular references, but on the other computer, it went ahead and did the calculations anyway, now it won't. I have tried changing the number of iterations to 1 and still it will not carry out the calculation.
Here is my code (which was working on the other machine)

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Not Intersect(Target, Range("INCHESRANGE71240801")) Is Nothing Then
Application.EnableEvents = False
Range("MILLIMETERSRANGE71240801").Formula = "=CONVERT(E11,""in"",""mm"")"
Application.EnableEvents = True
ElseIf Not Intersect(Target, Range("MILLIMETERSRANGE71240801")) Is Nothing Then
Application.EnableEvents = False
Range("INCHESRANGE71240801").Formula = "=CONVERT(E62,""mm"",""in"")"
Application.EnableEvents = True
End If
End Sub

the millimeters range and inches range are pretty self explanatory.

PLEASE HELP
thanks
~hollanu~

[hollanu]

well after messing around with it for a while, I found out that I did not have the analysis tool pak add-in loaded.
thanks for looking anyway.