calling worksheet function from a macro
 

Hi
I have written a macro in which i need to call the spreadsheet function
Fact. This gives me an error. Most of the spreadsheet functions are
simply called by using their names but not this one. Anyone have any
ideas on how to do this. By the way using the Fact function in a work
sheet does fine.

calling worksheet function from a macro
 

One generally uses
MyVar=Application.WorksheetFunction. then a drop list pops up showing
which Excel function may be used in VBA
In general, if VBA has an equivalent function, you cannot use the VBA
function (e.g MAX, SUM)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Joe Farruggio" wrote in message
...
Hi
I have written a macro in which i need to call the spreadsheet function
Fact. This gives me an error. Most of the spreadsheet functions are simply
called by using their names but not this one. Anyone have any ideas on how
to do this. By the way using the Fact function in a work sheet does fine.

calling worksheet function from a macro
 

Joe

You need to use the WorksheetFunction property of the application object

result=Application.WorksheetFunction.Fact(........ .....)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England

HIS
www.nickhodge.co.uk

"Joe Farruggio" wrote in message
...
Hi
I have written a macro in which i need to call the spreadsheet function
Fact. This gives me an error. Most of the spreadsheet functions are simply
called by using their names but not this one. Anyone have any ideas on how
to do this. By the way using the Fact function in a work sheet does fine.

calling worksheet function from a macro
 

MsgBox Application.Fact(5)


--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Joe Farruggio" wrote in message
...
Hi
I have written a macro in which i need to call the spreadsheet function
Fact. This gives me an error. Most of the spreadsheet functions are
simply called by using their names but not this one. Anyone have any
ideas on how to do this. By the way using the Fact function in a work
sheet does fine.