using for loop to replace if-then-else

[bored]

Hi,

I have written the following:

Please Login or Register  to view this content.

This goes on for many more lines. Can someone pls show me how this can be converted to a for loop instead?

Thanks for any help.

[Norie]

Perhaps.

Please Login or Register  to view this content.

[bored]

Norie,

Thanks, that worked perfectly. I have some questions to ask you about your code.

1. what does the "\" mean in the line

Please Login or Register  to view this content.

2. what does this segment

Please Login or Register  to view this content.

do?

Thanks.

[Norie]

1. <dividend>\<divisor> is the Integer Division operator, it returns the no of times the divisor can divide the dividend ignoring the remainder.

Make sense?

How about an example?

5\4 returns 1

9\4 returns 2

13\4 returns 3

and so on.

We use it to get the no of columns we need to add to the range based on lastcolumn.

2 This will rerturn Columns(6), Columns(10), Columns(14) etc based on what I is.

Please Login or Register  to view this content.

So if I was 2 we first add Columns(6) to the final range, then we add Columns(10).

Any use?

[bored]

Thanks for the explanation! Got it now =)