"function" vs. "worksheet function"

[Paul]

I've bashed around with Excel before, but now I'm having to dig into
the Help (on the web). The terms "function" and "worksheet function"
are pervasive. Are they basically synonyms? Thanks.

 

[JP]

"Function" is more general -- it can refer to a worksheet function, or
a VBA-based user defined function (UDF).


HTH,
JP

 

[Paul]

Indeed it does help. Thanks!

"Function" is more general -- it can refer to a worksheet function, or
a VBA-based user defined function (UDF).

HTH,
JP



- Show quoted text -

 

[Jim Cone]

"WorksheetFunction" is also a term used with/in VBA code.

 

[Paul]

"WorksheetFunction" is also a term used with/in VBA code.

The need for VBA is starting to nip at my heels. Thanks.

 

[Bob Phillips]

A function does not have to be a UDF, it is just a procedure that (can)
return a result.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Function" is more general -- it can refer to a worksheet function, or
a VBA-based user defined function (UDF).


HTH,
JP

 

[JP]

Noted. Thanks Bob!

--JP