Select number of rows in a graph?

C

cratediggah

Hi All,

I create a variable which counts the number of rows as 'NumRows' and
need to use it in the following vb:

ActiveChart.SetSourceData Source:=Sheets("Net
Sales").Range("A1:AD*INSERTROWSHERE*"), _
PlotBy:=xlColumns

How do I add the variable in this section? Thanks
 

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

indirect addressing 2
Specifiy Chart Data Range 1
Range Statement in chart 2
How to change the row number in macro code? 1
Trying to Learn Code to Copy Charts 2
using variables in the range of source data 8
Dynamic chart problem 1
Input data for graph 2

Top