Return value from a function

[cgi_pro]

Hello

I have the followig function

Function GetTheName() as string

Dim MyName as string

...
[Some Calculation here to get "MyName"]
...


[Returning the value of MyName]

End Function

How do I return this "MyName" here now then exit the function to go back to the calling procedure? I tried the "Return MyName" statement but it gave me a syntax error, however I tried "GetTheName = MyName" and it worked but is this going to flush the memory of this function from memory and exit the function and go back to the calling procedure?

[Bryan Hessey]

Hello

I have the followig function

Function GetTheName() as string

Dim MyName as string

...
[Some Calculation here to get "MyName"]
...


[Returning the value of MyName]

End Function

How do I return this "MyName" here now then exit the function to go back to the calling procedure? I tried the "Return MyName" statement but it gave me a syntax error, however I tried "GetTheName = MyName" and it worked but is this going to flush the memory of this function from memory and exit the function and go back to the calling procedure?

MyName = result.of.calculation

example

Function Area(Length As Double, Optional Width As Variant)
    If IsEmpty(Width) Then
        Area = Length * Length
    Else
        Area = Length * Width
    End If
End Function

hth
---