Hmmm - Works fine for me in 2000. What line does it error on? It didn't suffer
from wordwrap anywhere did it, such that you may see red lines of data in the
code when you pasted it in. Happy to send you a copy that is working on my
machine, and then if that doesn't work will have to think again as to what is
causing it. If you want me to send you that then email me taking the NOSPAM bit
out of my email address



--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"prodsched " wrote in message
...
Thank you so much for your quick response.

I have tried both routines and both cause and error message as
follows.

Runtime Error 438
Object doesn't support this property or method.

I have entered values for LastRow=ActiveSheet.UsedRange.Row-1+_

I have used positive and negative integers and keep getting the error
message.

Apparently I am still missing something here. Thanks again...


---
Message posted from http://www.ExcelForum.com/



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.608 / Virus Database: 388 - Release Date: 03/03/2004