Thread: Printing charts from VB - How to define range?

Hi,
I am trying to write some code which prints a chart to an excel worksheet (see module in attached workbook). I have recorded a macro which does most of the work, and am trying to edit this so that I can make it into a loop. I am having some trouble with defining the range for input data (line 33 in Module2), it would be great if someone could show me the correct way.

Thanks

You need to reference the sheet where the cells are

Code:

    ActiveChart.SetSourceData Source:=Sheets("Salinity_Obs").Range(Sheets("Salinity_Obs").Cells(Iref, Jref), Sheets("Salinity_Obs").Cells(Iref + Rownum - 1, Jref + Colnum - 1)), _
        PlotBy:=xlColumns