Stop Loop Each Condition – Using FirstFreeRow
My issue is i’m running the loop each condition to select data from rows in excel and I cannot get it to stop the looping when it reaches the last row that contains data.
I’ve impletmented the %FirstFreeRow-1% condition but I must be missing something out.
Any help would be greatly appreciated.
Thanks in advance.
Attach your project, perhaps I can you something to help.
Sorry for my English. I am a Russian 🙂
Hi David, I think I know what the issue is here. Please make sure that you do not have any cells that have been used but not containing any data at the moment. What I mean is that you should delete all rows that do not contain any data, to make sure that there’s no formatting in them to make them active. You can check that by displaying the %FirstFreeRow-1% variable in a message box to give you what is considered to be the first free row. If there are other empty rows above the one displayed, make sure you select them, and delete them. When you then run the job again, the job should work as you want it to. PS. even cell formatting (bold weight to fonts, a border formatting, etc) applied to a row will mark the current row as active and therefore as full of data. Samantha
Our Technical Support Forum is Going Social!
Attention, great news! This forum will soon be transferred to LinkedIn. If you are a WinAutomation customer please send us a request to join WinAutomation Customer Technical Support LinkedIn group.
You may also request WinAutomation support by opening a support ticket.
Alternatively, you may contact us via email at email@example.com or, for general inquiries, you can send us your message by submitting the Contact Us webform.
Thank you for Automating with us!
Viewing 3 posts - 1 through 3 (of 3 total)