Re: Find Combinations, Delimit, and Paste into new Tab
Oh I'm sorry, I'm an idiot and included the Month headers in that count. It is 125. 3 months 5 variables (5*5*5) = 125. duh
It works perfectly using exactly what you gave me for 3 months! I changed it to 2 months using the -2,-1,0,1,2 already there and it tells me to debug this line: Range("A4").CurrentRegion.RemoveDuplicates Columns:=Array(1, 2, 3), Header:=xlYes
Also when testing 4 months it only gives me 125 lines? When it should be 625 rows?