Loop till zero

Hi,

As shown below I want to create a dynamic range in excel vba till split 50 to 9 segments.
It should stop when the left count becomes 0.

No. of Segments 9
no of flowers 50

No. of Segments Flowers in each segment Left
9 5 45
8 5 40
7 5 35
6 5 30
5 6 24
4 6 18
3 6 12
2 6 6
1 6 0
0 #DIV/0! #DIV/0!

Please suggest
calculate.xlsx

For me it is not clear what you want to achieve, and why you posted in http://www.excelforum.com/excel-programming-vba-macros/

1) do you want 9 or 10 (9...0 has 10 members) segments?

2) as we are in VBA subforum try

Please Login or Register  to view this content.

Hi Kaper,

You understood it very well and the solution worked like a charm. I just changed Round(people / i) to Int(people / i).

Many thanks