View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.programming
dim dim is offline
external usenet poster
 
Posts: 123
Default Specifying Cells To Copy Across Workbooks Not Working!

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