Hi all,

Ok I am trying to establish a loop whereby after every 6th count a variable is changed.

Therefore:-
if count = 1 to 6 then yval = 20
if count = 7 to 12 then yval = 160
if count = 13 to 18 then yval = 300

...carries on adding 140 to yval with each count range of 6.

The count is not fixed and continues until it reaches a blank cell.

I thought about dividing count by 6 and rounding down to get whole numbers that I could multiply yval by each time but there is no easy way to round down in vb that i can see.

Any ideas would be appreciated.

Thanks,
Gboy