Posted to microsoft.public.excel.programming

[email protected] ucanalways@gmail.com is offline

external usenet poster

Posts: 115

One line query on for loop assignment

I have a line
ActiveChart.SeriesCollection(i).Name = Sheets("Sheet1").Cells(j, 2)
for assigning the legend name in a scatter chart which works
correctly.

I would like to assign .values from cells(j,1) to cells(k,1).. What is
the correct syntax to do it?
I get an error when I have a line like this.

ActiveChart.SeriesCollection(i).Values = Sheets("Sheet1").Cells(j,
1):cells(k,1)

Thanks

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
Line Chart Query	Furn16	Charts and Charting in Excel	1	December 19th 09 02:36 AM
Do without loop when using query	[email protected][_2_]	Excel Programming	1	June 7th 07 05:09 PM
LOOP query	Pedro AM	Excel Discussion (Misc queries)	2	February 14th 07 05:32 AM
Code bombing on Loop While line	JMay	Excel Programming	3	December 26th 05 10:16 PM
Looping SQL query w/changing parameters in each loop not working	Laurin[_3_]	Excel Programming	7	December 9th 05 03:35 PM

All times are GMT +1. The time now is 05:34 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us