VBA - Convert my variable range array to single cell string

Posted to microsoft.public.excel.programming

Kevin G[_2_] Kevin G[_2_] is offline

external usenet poster

Posts: 13

VBA - Convert my variable range array to single cell string

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Convert YYYY, MM, and DD as a single number string	rmorrison	Excel Discussion (Misc queries)	13	September 20th 08 05:27 PM
Finding max array value of variable cell range	The Fisherman	Excel Discussion (Misc queries)	0	February 6th 07 02:54 PM
Passing string as array variable (Pivot VBA)	klingongardener	Excel Discussion (Misc queries)	2	December 23rd 06 07:58 PM
how do I make single character as a variable in an array	Hazlgrnguy	Excel Worksheet Functions	1	September 25th 05 08:12 AM
Problem trying to us a range variable as an array variable	TBA[_2_]	Excel Programming	4	September 27th 03 02:56 PM

All times are GMT +1. The time now is 09:40 PM.

Menu

About Us