I am trying to figure out a way to set a default value. For example:

In a code like:

Function WS(rng As Range) As String
WS = "The name of the worksheet is " & rng.Worksheet.Name & "."
End Function

If no argument is inserted I want the rng of the active cell to be considered.

--
Best Regards,

Faraz