Does anyone have a permutation/combination macro for Excel?

I'm not interested in the calculation. That's the easy part. I'm
looking for a macro that outputs the entire list of permutations or
combinations of a given set of numbers or letters.

I found the following online but I am getting a compiling error in
Excel:

Dim rSrc As Range, rDst As Range, rITM
As Range <<<<< SYNTAX ERROR IN THIS LINE
Dim cItm As Collection, vItm()

Macro taken from here (cached because you will get strange popups
otherwise):

http://64.233.167.104/search?q=cache:d9d4pvIsSj4J:www.alegsa.com.ar/Visitas/index23/Creating%2520a%2520combination%2520or%2520permutation%2520array%2520in%2520excel.php+permutation+excel&hl=en&client=firefox-a

TIA!

.

Relevant Pages

  • RE: Form calculation based on the date - How to????
    ... Access can't find the macro 'txtTotalDollarAmount_Bound = ... "Could it be that the control source for the form's field is now no longer ... txtTotalDollarAmount or txtTotalDollarAmount_Bound ... ... date field and then run the correct macro calculation based on that date. ...
    (microsoft.public.access.modulesdaovba)
  • Re: How can I change the default manual calculation as automatic
    ... We're using the method of macro. ... The automatic calculation seems solved. ... they didn't want to give us the admin right for security reasons. ... It is the first Workbook that is opened in any Excel session that sets ...
    (microsoft.public.excel.misc)
  • Re: update worksheet keeping formula
    ... I copied the wrong version of the first macro out of my library of code. ... Dim myCalc As Variant ... .Calculation = xlCalculationManual ... For Each myCell In Selection.SpecialCells ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Return calculated value to form
    ... Double check the OnClick PROPERTY in the PROPERTIES window for the button to ensure that is listed, this points the event to the procedure as opposed to a macro. ... I have had to put the vba code in each form where it is used instead of being able to use a public function which would be easier and save time. ... Otherwise, if you want the calculation to run on demand, as opposed to being automatically updated, in the onClick event of a button use the code ...
    (microsoft.public.access.modulesdaovba)
  • Re: Macro muddle, eliminate the nag
    ... Steve, thanks for your reply. ... OpenQuery macro action, in the form’s After Update event, as you suggested. ... until control passes out of the record. ... duplicate of the calculation - temporarily displaying, in other words, the ...
    (microsoft.public.access.gettingstarted)