[SOLVED] Printing charts from VB - How to define range?

HammerTime · #1 07-19-2009, 08:48 PM

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

Andy Pope · #2 07-20-2009, 07:45 AM

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

Welcome to the Excel Forum

Forum Statistics