office 2007, excel, XP, dell laptop
Of course when I upgraded to office 2007, I have to port my macros.
I am getting a syntax error on this function and do not know why.
Help button is not much use.
Function Get_Value()
Dim Value As Integer
Value = 10
Return Value ' <-- syntax error shows here
End Function
How is one supposed to return a value from a function?
This did not work either:
Function Get_Value() As Integer
Get_Value = 10
Exit Function
End Function
Thanks - Pop Tufty
Jim Rech - 19 Jan 2008 16:50 GMT
>>This did not work either:
Yes it does.
>>Exit Function
You don't need this, not that it does any harm.

Signature
Jim
> office 2007, excel, XP, dell laptop
>
[quoted text clipped - 17 lines]
>
> Thanks - Pop Tufty