Excel 2007 VB function call return value syntax question

[pop tufty]

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]

This did not work either:

Yes it does.

You don't need this, not that it does any harm.