Assume you had a range J9:J11

J9: 1
J10: 2
J11: 3

What would you expect to see in the single cell?

--
Regards,
Tom Ogilvy

Kevin G wrote in message
news:LZFRb.19360$P51.3159@clgrps12...

I have a range a cells J9:J520 (this range only used for a chart series)
and I am trying to convert this to a string so it can be pasted into a
single cell. I would like to convert this back to a variable range when
needed to chart again.


Thanks, Kevin