Forum

I find the way by myself! I change it a little, it works. you can see that: Sub Spiral_new() Dim userinput As Long, n As Long, i As Long, j As L...

Hi Dear H attached a simple file. start from a cell like I10 and move spiraling to cell J10 , J11 , I11 , ... anf fill cells by counter.

Hi I added an attachment.

SunnyKow said Try this =SUMPRODUCT(C2:C10,CHOOSE({1;2;3;4;5;6;7;8;9},B2,B3,B4,B5,B6,F2,F3,F4,F5)) You should get the answer 793 Sunny Gre...

No, I know the concatenating some texts, but it should be as number for some other calculations. The simple file is attached.