I have a list box operating from a named range which
contains duplicates. I need the duplicates for later
calculations so don't want to delete them, but obviously,
don't need them showing in the list box.

Any suggestions?

Thanks, your help will be greatly appreciated.

Helen

http://www.j-walk.com/ss/excel/tips/tip47.htm

This will help you Helen

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Helen Hope" wrote in message ...

I have a list box operating from a named range which
contains duplicates. I need the duplicates for later
calculations so don't want to delete them, but obviously,
don't need them showing in the list box.

Any suggestions?

Thanks, your help will be greatly appreciated.

Helen