How about the rest of the code? Can you step through it to follow what it's
doing? If so, try recording a macro doing the tasks the code is supposed to
do. Then copy and paste that into the correct spot in the code.

I have run into this exact situation myself, and sometimes this
bass-ackwards way actually solves the problem.

Pflugs

"darthrader" wrote:


I believe so. The code is complicated and was written a while ago by
someone else in the company. I am trying to make it work on 2003. It
runs perfectly on Excel 2000. Does not make sense to me.

Thank you


--
darthrader
------------------------------------------------------------------------
darthrader's Profile: http://www.excelforum.com/member.php...o&userid=36359
View this thread: http://www.excelforum.com/showthread...hreadid=561465