Incrementing Cells based on a value

[That1Dude]

The question proposed is...

You have 3333 lockers and 3333 kids
All the lockers start closed.
Kid 1 opens every locker
Kid 2 changes ever 2nd locker starting with the 2nd
kid 3 changes every 3rd locker starting with the 3rd
so on and so forth until all the kids have been through the lockers.

Question is how many lockers will be left open?

I am trying to do this in excel solely for the experiance of it and this is what I have so far...

I am just trying to write a value of 1 or currentcell +1 if the kid touches the lock then I can use odd and even to tell if the locker is open or closed.

Please Login or Register  to view this content.

I could just be completely out of track with this as this is my first time using VB and VB in excel.

Where I have

Please Login or Register  to view this content.

I was just trying to use column A row lockers what ever the current locker number may be.

[JBeaucaire]

Hi Dude... Welcome to the forum.

Be sure to read through the Forum Rules so you can use and follow them effectively. For instance, you'll need to EDIT that post above and put code tags around that code you used. (Like shown in my signature)

Also, your title is a second rule breach, change your title to one that accurately summarizes the topic. Read your post again, I'm sure a more accurate title will occur to you.

[That1Dude]

Hi Dude... Welcome to the forum.

Be sure to read through the Forum Rules so you can use and follow them effectively. For instance, you'll need to EDIT that post above and put code tags around that code you used. (Like shown in my signature)

Also, your title is a second rule breach, change your title to one that accurately summarizes the topic. Read your post again, I'm sure a more accurate title will occur to you.

Thanks for the advice on fixing up my thread, hope this better meets the necesary criteria.