Using Range names in selecting chart series.

G

GC

Hi,

I have a range named DataCount. This will count the number of data points i
have in a column. I would like to use this information when specifying the
series range in chart.



ActiveChart.SeriesCollection(1).Values = "='System 4'!R2C13:R35C13"

In this example I need to substitute R35 with DataCount.



What is the correct syntax?



Thanks in advance,

Cherrs!
 
J

Jon Peltier

What kind of variable is DataCount? Is it a named range? A VBA
Excel.Range object? A string that contains an address? Does it reference
R35 or R35C13?

- Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help using indirect addressing in chart series 2
Changing chart data ranges from VBA code 3
VBA access to a series, after it was assigned to an empty range 0
add a chart in a Add-In 1
Automatically selecting active chart 4
Creating a Chart on form from selected data in query. 0
adding a data series to a chart with variable inputs. 2
Unable to get SeriesCollection runtime error 3

Top