"I'll write out a Select Case with 3000 or so Case Is = "
DON'T DO THAT - find another way!

"I don't understand that its working for you!"
I made up a couple of test workbooks using your workbook and sheet names.
I assigned a value of 6 to "n"
I ran the code.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"dim"
wrote in message
No problem Jim,
Thankyou very much for all the help. I have to say I'm a bit miffed that
it's working for you...thats just confusing me more! lol :-)

I guess I'll do it the hard way...I know this way will work but I thought
there must have been a better way. I'll write out a Select Case with 3000 or
so "Case Is = " to cover the selection of any of the list items. Some of my
lists have up to 3000 items, others have about a hundred. It'll take a while,
but if I had started last week instead of trying to find an easy way, I'd
have some done by now! Haha! Such is life. :-)
If anyone figures this out I'd appreciate a heads up. L8rs. Thanks again.



"Jim Cone" wrote:
Sorry, but I am out of ideas.
Jim Cone