Can't figure out loops

**kevnin** · 06-27-2008, 01:18 PM

Hey all, I'm having a bunch of trouble getting loops working in my macros (I have a background in C++ and PHP, not very familiar with VB)

Anyway, here is my code:

Please Login or Register  to view this content.

It's supposed to traverse through a row, create new worksheets named from the cell contents.

It only runs one time. I have checked a million tutorial sites and they all list this as the proper syntax... Is there something within the statements that causes it to not function the way I would like?

Thanks in advance.

edit: also, the code within the loop came from http://www.mindspring.com/~tflynn/ex....html#AddSheet in case anyone recognizes it

**slx** · 06-27-2008, 01:33 PM

Try this do while loop. Well that code requires u to be highlighting the first cell with the worksheet name.

Please Login or Register  to view this content.

This assumes that cell values are continuous and the first empty cell it comes up is the eof

**se1429** · 06-27-2008, 02:48 PM

Hi,

After the first worksheet is created, it becomes the active sheet and the do while loop will be evaluated there. Since all cells are empty the loop will end.
To set focus back to your original sheet add the following line:

Please Login or Register  to view this content.

before

Please Login or Register  to view this content.

change "sheet1" to the actual name of your worksheet.

Regards.

**shg** · 06-27-2008, 05:42 PM

You could do it like this:

Please Login or Register  to view this content.

A number is a valid name for a sheet, BTW ...

**kevnin** · 07-02-2008, 11:15 AM

Thanks for the input everyone.
As se1429 pointed out, when I add the new sheet it becomes the active sheet, changing my active cell. This is a big problem, because If I make the original sheet active, the activecell becomes A1. Is there a way to add a sheet without making it active?

(also, shg's version only ran once because of the same reason)

**shg** · 07-02-2008, 11:42 AM

(also, shg's version only ran once because of the same reason)

Don't think so. Select cell A1 and push the Run button.

To be more specific, the items (cells) in the collection over which the loop iterates is set when the loop starts; changing the active sheet does not change the collection. (I'm referring to my code.)