Looping Problem

**Spasm** · 07-09-2011, 06:44 AM

hi

i run the following code on file "1"

Please Login or Register  to view this content.

then i update the files which got created, with the contents of file "2" with the following code

Please Login or Register  to view this content.

it keeps on looping after the last row
hence
i need help with the looping problem

thanks

**tigertiger** · 07-09-2011, 08:49 AM

Changing "ActiveCell" in the process of sub need to be mentioned - your code seem ignore the problem

**Spasm** · 07-09-2011, 09:34 AM

means ?

didnt get you ?

**Marcol** · 07-09-2011, 10:28 AM

Try this.

Please Login or Register  to view this content.

Note the Error Handler
You should have something similar in "Macro3"

Also this will overwrite files "a", "b","c", etc in row two each time you run it, I suspect this is wrong.
If so Try this

Please Login or Register  to view this content.

Hope this helps

**Mordred** · 07-09-2011, 10:34 AM

This a a cross post from here. Spasm, if Marcol's code doesn't work, perhaps you should upload a mock workbook with mock data. This workbook should indicate exactly what you want to happen with the data, both before and after.

**royUK** · 07-09-2011, 11:10 AM

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.