Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
excell macro calls spreadsheet function
1 view
Skip to first unread message
Joe Farruggio
Nov 20, 2006, 4:29:44 PM11/20/06
to
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.
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.
Ivyleaf
Dec 18, 2006, 8:21:32 PM12/18/06
to
Hi Joe,
Try calling it as you would any other worksheet function:
WorksheetFunction.Fact(Value)
Cheers,
Ivan.
0 new messages