Combinations & Perms

[GK]

I know this question has been asked and answered many times over. I just
need a little help understanding the finer points. OK, Here goes.

I am attempting to find a way to calculate all of the possibilities of a
group/numbers givin certain restrictions. I have found Myrna Larson's
formula originally posted in July of 2000. One of the pages is code is listed
on is here...http://www.ozgrid.com/forum/showthread.php?t=28321

Where I really need help is in the set up. Where do I put this code to get
it to run? I am using Office 2007/Excel. Please help.

Thanks,
GK

 

[Toppers]

See here for help on macros:

http://www.mvps.org/dmcritchie/excel/getstarted.htm

 

[GK]

I tried what I believe I was supposed to do but I get an error. It says
overflow.

 

[Toppers]

Overflow usually occurs when you have a number which is greater than is
possible in a variable type e.g. very large number in an integer (rather than
LONG) variable.

I have used this code frequently and haven't had any problems.

What is your input data?

 

[GK]

C
3
1
2
3
4
5

That is exactly my input data. I was attempting to do a test to see if I
was putting in the code correctly.

PLease help!!!!

Thanks, GK

 

[Toppers]

No problem here with your data.

I assume you haven't changed the code AND it was copied correctly?