Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 9
Default calling "Fact()" from a macro in excel 2002

Hi
Does anyone know how to call either the "Fact(x)" or the "Combin(x,y)"
functions from a macro? I need to have x and y as variables obtained
from inputs to the program as it is running.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 35,218
Default calling "Fact()" from a macro in excel 2002

See your other post and

MsgBox Application.Combin(13, 5)

may give you an idea.



Joe Farruggio wrote:

Hi
Does anyone know how to call either the "Fact(x)" or the "Combin(x,y)"
functions from a macro? I need to have x and y as variables obtained
from inputs to the program as it is running.


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel macro [email protected] Excel Discussion (Misc queries) 1 May 27th 06 04:00 PM
excel 4.0 macro removal tool Sachin Shah Excel Discussion (Misc queries) 0 August 25th 05 04:17 AM
excel 4.0 macro remover tool Sachin Shah Excel Discussion (Misc queries) 0 August 25th 05 04:14 AM
how to convert GETPIVOTDATA from excel 2000 to excel 2002... Need_help_on_excel Excel Worksheet Functions 1 March 15th 05 01:08 AM
How can I see a list of macro key assignments in Excel 2002? Echoesrad Excel Worksheet Functions 0 November 10th 04 06:44 PM


All times are GMT +1. The time now is 02:16 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"