Macro ignoring Loop

**chcwebb** · 06-18-2009, 03:51 PM

I have writtent the following macro, which is called in a larger macro. It is supposed to search a "Data" worksheet for names which do not appear in a "Staff List" worksheet in another spreadsheet, and add any missing names to the "Staff List" worksheet. However, when I run this macro, it will find the first missing name, add it appropriately, and then end the macro, ignoring the loop. There are many missing names which it should be finding, but it only finds one every time it runs. It is a different one every time. Any suggestions?

Please Login or Register  to view this content.

**shg** · 06-18-2009, 04:22 PM

Welcome to to the forum, chcwebb.

Please take a few minutes to read the forum rules, and then edit your post to add code tags.

Thanks.

**mudraker** · 06-18-2009, 05:15 PM

Your code does exactly what you have it coded to do - It loops once

Within your loop you select the last used cell

Please Login or Register  to view this content.

You then select the next row and populate that with formulas

Before the Loop command at the end of your Do Loop you then select the next row down which is blank

Please Login or Register  to view this content.

P.S Macros can be coded do that you do not need to select cell all the time

**chcwebb** · 06-19-2009, 10:24 AM

What is happening, if I am rereading my code correctly, is:

If the name in "Data" is not in "Staff List" Then

Open "Staff List", go to the first blank row, and paste the appropriate information into the row.

Then go back to the "Data" worksheet, go down a row, and keep on searching.

Since the Selection.End(xlDown).Select is in the "Staff List" sheet, and the macro is cycling through values in the "Data" sheet, this should not end the macro prematurely, right?