loop question

[GBoy]

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

[mudraker]

Add these commands after your counter is increased

Please Login or Register  to view this content.

It sounds like you are intending to use a Do type loop

Here is a way to loop using a For type loop where you get the end row number before you start the loop

Please Login or Register  to view this content.

[GBoy]

I like that, very clever!

Thanks for your help.

[mudraker]

GBoy

If you are refering to (counter Mod 6) as being very clever I thought so to when I seen it posted in another thread a couple of days ago.