Re: Find Combinations, Delimit, and Paste into new Tab
I actually get the green triangles on all the values too...
I don't know why.. but maybe a workaround is this..
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...