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???????
Do you have one session open of Excel or more ?
Working correct here with one Excel session open.

Signature
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
>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???????