The statement below is not entirely true.
Actually, Functions do not have to be used only in Formulas.
A Function can be called by VBA code also.
A couple of examples.........one with a User Defined Function...........
Sub foo()
MsgBox "The row height is " & rowht(ActiveCell)
End Sub
Function rowht(x)
Application.Volatile
rowht = x.RowHeight
End Function
One using an Excel Function............
Sub foo2()
MsgBox "The Total is " & Application.WorksheetFunction.Sum(Range("A1:A32"))
End Sub
Gord Dibben Excel MVP
On Tue, 01 Mar 2005 18:35:09 -0800, Gord Dibben <gorddibbATshawDOTca wrote:
francine
Formulas can use Functions or not.
Functions have to be used in formula mode.
This is a formula =A1+A2+A3+A4+A5+A6+A7
This is a formula with a Function in use =SUM(A1:A7) which saves you a lot of
typing.
Gord Dibben Excel MVP
On Tue, 1 Mar 2005 15:17:03 -0800, "francine"
wrote:
my question is what is function vs. formula?
I need to know so that I can study for finals. I'm trying to get as much
information as I can on the subject so that I may possibly get a good grade
|