Do you have one session open of Excel or more ?
Working correct here with one Excel session open.
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"Millie" wrote in message ...
I followed the directions from the previous post, but this doesn't work. In
the drop down box there is only the worksheet that you copy from and "new
workbook". The other workbooks I have open are not listed in the drop down
box. What's the fix for this problem???????