Loop is not working

[KColgrove]

Hello,

I am trying to make a loop that will loop through a table and if the task hasn't been completed it will send out an email (I'm just testing it right now so I just want to display the email). But when I run the code it only displays 1 of the emails, when it should be displaying at least 4 right now. When I run the code line by line doing f8 the code works perfectly. Is there something I need to add that will slow it down or make sure that it runs through the full loop? I'm not 100% sure I'm using GoTo correctly.

Please Login or Register  to view this content.

[KColgrove]

I figured it out. I needed to move sheets before I counted the rows. Was counting the wrong sheet...

[AliGW]

Thanks for letting us know.