Thanks for the assistance. Tried several different options but have
question on the amount of data it can process. When I run it against
100 row sheet the code works fine. When I try and run it against th
entire sheet (2628 rows) it just hangs. I've tried to let it run fo
30min (just in case) but no progress was shown.

Is there a limit on what excel can handle?

Thinking my only option is to break the sheet up into apx 500 rows pe
sheet and then running and cut and paste them back in.

Any ideas

--
christia

-----------------------------------------------------------------------
christian's Profile: http://www.excelforum.com/member.php...fo&userid=1436
View this thread: http://www.excelforum.com/showthread.php?threadid=26175

I don't know what this looks like in the Excel forum, but in the newsgroup
where most of the answers are coming from, this stands by itself at the top
of a thread; so I doubt anyone knows what you are talking about. (in
otherwords, no one can see what you are referring to).

--
Regards,
Tom Ogilvy

"christian" wrote in message
...

Thanks for the assistance. Tried several different options but have a
question on the amount of data it can process. When I run it against a
100 row sheet the code works fine. When I try and run it against the
entire sheet (2628 rows) it just hangs. I've tried to let it run for
30min (just in case) but no progress was shown.

Is there a limit on what excel can handle?

Thinking my only option is to break the sheet up into apx 500 rows per
sheet and then running and cut and paste them back in.

Any ideas?


--
christian


------------------------------------------------------------------------
christian's Profile:
http://www.excelforum.com/member.php...o&userid=14361
View this thread: http://www.excelforum.com/showthread...hreadid=261759