Is there any way I can test whether a function has been called because it is
used in a cell, or whether it is called from code?

Try commenting out the function and see if you get a code error or bad
references.

Andibevan wrote:
Is there any way I can test whether a function has been called because it is
used in a cell, or whether it is called from code?

Something like this perhaps

Function myFunc()
Dim x
On Error Resume Next
x = Application.Caller.Address
If Err.Number = 0 Then
MsgBox "Called from Worksheet"
Else
MsgBox "Called from VBA"
End If
On Error GoTo 0
End Function



--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Andibevan" wrote in message
...
Is there any way I can test whether a function has been called because it
is
used in a cell, or whether it is called from code?

Thanks for all the suggestions

Check out Application.Caller

NickHK

"Andibevan" .gbl...
Is there any way I can test whether a function has been called because it
is
used in a cell, or whether it is called from code?

One mo

if typename(application.caller) = "Range" then
'called from a cell
else
'not called from a cell
end if

(Case is important in "Range".)




Andibevan wrote:

Is there any way I can test whether a function has been called because it is
used in a cell, or whether it is called from code?

--

Dave Peterson