VBA -isn't working in Excell 2007, working in Excell 2003

[Evening]

I used a special VBA defined calculations in Excell under 2003 version, and it was working without problem. When I run this under 2007, isn't working. Why?

The calculations looks like this:

Function AngleSol(B As Double) As Double
' Find the value F such that F - Tan(F) = B

Dim Epsilon As Double
Dim Counter As Double
Dim F As Double

F = 0.1
Epsilon = Tan(F) - F - B
While (Abs(Epsilon) > 0.00000000001) And Counter < 100000
F = F * (1 - Epsilon)
Epsilon = Tan(F) - F - B
Counter = Counter + 1
Wend
AngleSol = F
End Function

 

[Evening]

I forgot to tell that if i open a create a new workbook in Excell 2007 and place the calcuations, it's working.
If I open the workbook in Excell 2007 which was created in Excell 2003, isn't working.
What's the difference?

 

[SkipVought]

What does, "isn't working" mean?

1. Does not run at all?

2. Errors on a particular statement? If so, which one and what eror?

3. Does not return the desired result? If so, what argument, & what result.

BTW, I'd use Do...Loop rather than While...Wend.

Skip,
[sub]
When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large[/sub]

 

[Evening]

Skip

Thank you for reply..

Basically it couldn't calculate the value...It was an error in field ... I found later that the macro wasn't set properly in Excell 2007... I am new in Excell 2007, very difficult to find appropricate command, but 2 hours later finally i succeded to enable the macro... Now it's working .
Anyway, thank you for reply again..

 

[SkipVought]

Glad I couldn't help

Skip,
[sub]
When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large[/sub]