HELP!!!!!!!!


Posted by Mary on February 04, 2002 11:12 AM

This is exactly what I am inputting I am getting a run time error!! Help Please

Charts("Chart1").ChartWizard _
Source:=Worksheets("Sheet1").Range(Cells(1, 1).Cells(10, 2)), _
Gallery:=xlLine, _
HasLegend:=True, CategoryTitle:="Year", ValueTitle:="Sales"
Next counter ' Increment counter



Posted by John on February 04, 2002 1:36 PM

It looks like you have a period between the two cell references instead of a comma:

Cells(1, 1).Cells(10, 2)

instead of:

Cells(1, 1),Cells(10, 2)