VBA to write permuatations for a given input

**bilalmussa** · 06-07-2015, 05:54 AM

Hi,

I was wondering if anyone can help me write permutations in VBA.

Suppose my inputs are A, B, C

I would like it to yield the following results each in a separate cell

ABC
ACB
BCA
BAC
CBA
CAB

I have used 3 For... Next loops however, this will not stretch if I have an input for A,B,C, D

Any suggestions / directions most welcome. I have attached what I have currently started.

Permutations.xlsm

**Richard Buttrey** · 06-07-2015, 06:51 AM

Hi,

Here's one way with your inputs in a contiguous range on row 1 starting in A1.
Row 2 should be blank, results listed down column A starting at A3

Please Login or Register  to view this content.

**bilalmussa** · 06-07-2015, 01:06 PM

Hi,

It seems to be going in the right direction but it repeats itself like the below which isn't what I want.
abc
bca
cab
abc
bca
cab

How can the code be amended so that it does all the perms ?

Bilal

**Richard Buttrey** · 06-08-2015, 06:48 AM

Hi,

Substitute this code instead

Please Login or Register  to view this content.

VBA to write permuatations for a given input

LinkBack

Thread Tools

Rate This Thread

Display

VBA to write permuatations for a given input

Re: VBA to write permuatations for a given input

Re: VBA to write permuatations for a given input

Re: VBA to write permuatations for a given input

Thread Information

Users Browsing this Thread

Similar Threads

Function to Input sets of data, then write the output

[SOLVED] ?How to Write New Input (from userform) to top (row1) each time?

input items and write into a sheet then select some datas

write a macro to input data

[SOLVED] write macro to input data

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions