Looping Problem

**Spasm** · 07-08-2011, 08:30 PM

hi...

i use the following code to update some files.

Please Login or Register  to view this content.

When it reaches the last row, it keeps on looping.
i want it to stop after the last row is done......

Please help...

Thanks

Additional details:-

the cell values in the first column are the names of the files stored on my hard disk,
if a file is not present on my hard disk for upgradation, it will give error...
hence i m forced on using the error handler,
but its messing up the loop.

Plz help

**Leith Ross** · 07-08-2011, 09:12 PM

Hello Spasm,

Here is your macro with a few revisions.

Please Login or Register  to view this content.

**Spasm** · 07-08-2011, 09:46 PM

hi....
thank u for helping me with the code

but it gives an error at

Please Login or Register  to view this content.

( 3rd line from bottom )

**Mordred** · 07-08-2011, 10:18 PM

Does the following work?

Please Login or Register  to view this content.

This was not tested except for at compile time. I really don't know if it will do what you want at run-time. I was just playing with your code.

**Spasm** · 07-08-2011, 10:28 PM

thank U for ur effort

but the code has some problems
i tried it....
it keeps on looping on the 2nd row... it does not increment,, and it also keeps on prompting to save the file...

**Mordred** · 07-08-2011, 10:41 PM

Maybe:

Please Login or Register  to view this content.

**Leith Ross** · 07-08-2011, 10:50 PM

Hello Spasm,

Sorry, I forgot to exit when the cell is empty. Try this instead...

Please Login or Register  to view this content.

**Spasm** · 07-08-2011, 10:59 PM

thanks ......

**Spasm** · 07-08-2011, 11:04 PM

thanks

**Spasm** · 07-08-2011, 11:19 PM

hi Leith Ross
i tried the second code
but it didnt run at all

thank u for ur effort n time

**Leith Ross** · 07-08-2011, 11:22 PM

Hello Spasm,

I can not help you further on this problem because I have no idea what you are doing on your end that is causing the code to fail. The code works on my machine and I am running Excel 2003 under Windows XP. Perhaps, you will figure it out in time.

**Spasm** · 07-08-2011, 11:23 PM

hi Mordred
i tried ur second code
it increments but always prompts to save the file
and when an error occurs,,, it stops incrementing and auto closes itself

thanks for ur effort

**Spasm** · 07-08-2011, 11:37 PM

its ok

i m sorry for not providing enough information about my problem

thanks for your time and effort

**royUK** · 07-09-2011, 11:11 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.

**Marcol** · 07-09-2011, 12:04 PM

Hmm?
We seem to be in a bit of a mess here!

Is this thread closed or not?
The duplicate certainly is and that's where I posted a solution that works for me!

**Spasm** · 07-09-2011, 01:07 PM

ok

thanks

**Spasm** · 07-09-2011, 01:33 PM

2 files for my code problem

**Mordred** · 07-09-2011, 01:43 PM

I added one line of code to your existing code from post 1, will it work? Maybe.

Please Login or Register  to view this content.

I added

Please Login or Register  to view this content.

**Spasm** · 07-09-2011, 01:52 PM

ur code did everything perfectly as i wanted
but once the last row was done
it kept on looping until row 65536

**shg** · 07-09-2011, 02:08 PM

At a glance, you need an Exit Sub statement after the Loop statement.

**Mordred** · 07-09-2011, 02:10 PM

Have you tried the code that I provided in post #18? shg is no doubt right so maybe instead of

Please Login or Register  to view this content.

you should have

Please Login or Register  to view this content.

**Mordred** · 07-09-2011, 02:16 PM

It could be

Please Login or Register  to view this content.

that is causing the most problems, specifically

Please Login or Register  to view this content.

which puts you right back into the loop.

**Spasm** · 07-09-2011, 02:18 PM

yesssssssssss yaaaaaayyyy,,
i added EXIT SUB after the loop, and the macro worked perfectly fine.. did everything perfectly and didnt kept on looping after the last row

thank U Mordred
&
thank u SHG

for your amazing help and for giving ur precious time to solve my problem

thank u ALL

**Mordred** · 07-09-2011, 02:20 PM

We are glad to help. If you feel that your problem has been solved, mark this thread as solved and, if you are happy with the help you have received, don't be shy and tap the scales of those that helped.

Cheers

**Spasm** · 07-09-2011, 02:25 PM

yes .... added reputation for both of u

**Marcol** · 07-09-2011, 02:28 PM

The solution I offered in your closed duplicate thread works, and solves other problems that might arrise.

You PMd me to say it doesn't work, I can't see why this should be the case, but if your happy, so am I.

**Spasm** · 07-09-2011, 02:32 PM

no no.... plz dont take me wrong, ur code has to b precise
i appreciate what u did for me

it was my fault
i hadnt mentioned precisely what i wanted to do with the code

Looping Problem

LinkBack

Thread Tools

Rate This Thread

Display

Looping Problem

Re: Looping Problem

Re: Looping Problem

Re: Looping Problem

Re: Looping Problem

Re: Looping Problem

Re: Looping Problem

Re: Looping Problem

Re: Looping Problem

Re: Looping Problem

Re: Looping Problem

Re: Looping Problem

Re: Looping Problem

Re: Looping Problem

Re: Looping Problem

Re: Looping Problem

Re: Looping Problem

Re: Looping Problem

Re: Looping Problem

Re: Looping Problem

Re: Looping Problem

Re: Looping Problem

Re: Looping Problem

Re: Looping Problem

Re: Looping Problem

Re: Looping Problem

Re: Looping Problem

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions