ForSale

The reference doesn't copy over just because you copy the code. The new
workbook doesn't have the reference set. If you would like to copy the code
to different workbooks, consider using late binding.

http://www.dicks-clicks.com/excel/olBinding.htm

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

"ForSale " wrote in message
...
yes, i have the reference. here's what's throwing me for a loop.
i have a workbook with that code that works. i opened it, copied the
code word for word and put it in a new workbook. i ran the original
and it works, but doesn't work on the second workbook. what the world?


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