Myrna Larson code for Combinations and Permutations not working in Excel 07-Overflow

I've used the following code in Excel XP with no problems.
Now that I have Excel 2007, I keep getting an "Overflow" error when trying to run the code. Sometimes it will say "Runtime error '6':, Overflow"

When I step through the code (F8) the line that brings up the error is:

If N > Cells.Count Then GoTo DataError

To give an example of what values I'm entering use the following:

Cell A1 = c
Cell A2 = 5
Cells A3 - A17 = A-O (one letter per cell)

Any help would be greatly appreciated.

Please Login or Register  to view this content.

Welcome to the forum.

Please take a few minutes to read the forum rules, and then edit your post to add code tags.

Thanks. How about posting a workbook and explaining what it's suppose to do?