# Find Combinations, Delimit, and Paste into new Tab

• Re: Find Combinations, Delimit, and Paste into new Tab

Hi..

I actually get the green triangles on all the values too...

I don't know why.. but maybe a workaround is this..

Code
For Each xCell In Sheet2.Range("A1").CurrentRegion.Offset(1)
xCell.Value = CDec(xCell.Value)
Next xCell

You could do this or create some code that paste special (multiply by 1) all the cells in the range...

• Re: Find Combinations, Delimit, and Paste into new Tab

cool apo
thinking about it is in the options error checking .. i have probably turn mine off .. can you click the green error triangle and it should show more info .. and where the error options are

• Re: Find Combinations, Delimit, and Paste into new Tab

Did you consideer:

• Re: Find Combinations, Delimit, and Paste into new Tab

That's the only one (not 'several' ;))

But no doubt you already found out why.
Amended code:

• Re: Find Combinations, Delimit, and Paste into new Tab

quick in a decenting order .. thats a good consideer

• Re: Find Combinations, Delimit, and Paste into new Tab

To be specific: it's in the left to right order A2, B2, C2, D2, E2.
Whether descending or ascending is totally dependent of the values in A2:E2

• Re: Find Combinations, Delimit, and Paste into new Tab

what do you mean by: 'if you could nail the permutations' ?

• Re: Find Combinations, Delimit, and Paste into new Tab

Are you looking for:

• Re: Find Combinations, Delimit, and Paste into new Tab

cool bananas

• Re: Find Combinations, Delimit, and Paste into new Tab

I'm not familiar with that vernacular..... (?)

• Re: Find Combinations, Delimit, and Paste into new Tab

Thank you so very much for all the help, and I'm grateful I could highlight a potential issue that you all seemed to learn something from and solve.

pike, could you explain what the code in post #53 is for? Is this code for permutations only? I will test everything right now on my end to make sure I don't have any more errors.

• Re: Find Combinations, Delimit, and Paste into new Tab

pike, now if I'm not mistaken, the code you have in post #47 is the newest form (shorter too) that will accomplish the same thing as the previous macro (generate the combination results pasted as numbers, but starting in row J in the months tab)?

Just to clarify as this code is infinitely shorter, so I wanted to make sure that post #47 was the entire code and not a section I'm supposed to add to the existing code we were working on.

• Re: Find Combinations, Delimit, and Paste into new Tab

It seems you didn't notice it isn't @Pike's code but mine.

• Re: Find Combinations, Delimit, and Paste into new Tab

snb, you're right! The post before was that code too, terribly sorry!

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!