variable Question

  • Thread starter Thread starter Nigel
  • Start date Start date
N

Nigel

One way........

Dim ix as integer
ix = 27
ActiveChart.SeriesCollection(1).Values = "='Target Data'!R6C4:R" & ix & "C4"


Cheers
Nigel
Hi All,

How can i get R"26" to be a variable in the code below

ActiveChart.SeriesCollection(1).Values = "='Target Data'!R6C4:R26C4"

so that the answer becomes

x = 27

ActiveChart.SeriesCollection(1).Values = "='Target Data'!R6C4:R27C4"
 
Hi All,

How can i get R"26" to be a variable in the code below

ActiveChart.SeriesCollection(1).Values = "='Target Data'!R6C4:R26C4"

so that the answer becomes

x = 27

ActiveChart.SeriesCollection(1).Values = "='Target Data'!R6C4:R27C4"
 
thank you!!!!
One way........

Dim ix as integer
ix = 27
ActiveChart.SeriesCollection(1).Values = "='Target Data'!R6C4:R" & ix & "C4"


Cheers
Nigel
Hi All,

How can i get R"26" to be a variable in the code below

ActiveChart.SeriesCollection(1).Values = "='Target Data'!R6C4:R26C4"

so that the answer becomes

x = 27

ActiveChart.SeriesCollection(1).Values = "='Target Data'!R6C4:R27C4"
 
You must log in or register to reply here.

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

What's up with VBA (?) 4
Adding Chart problem 0
Value compare problem, As Single variables Feb09 3
Issue with Multiple Graph Creation in VB 1
check for alphabet in datalabel and then superscript that letter 4
Bubble Chart 1
Unable to set the xvalues property of the series class for a single row of source data 3
add a chart in a Add-In 1

Back
Top