MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Help - Syntax Error


Posted by Mary McLean on January 18, 2002 6:14 AM


Hi, Can anyone see what I am missing from the following statement. I totally used there outline for this but for summer reason it isn't liking it..It says needs = ?????????? PLease help

Charts("Chart1").ChartWizard(Source:=(Worksheets("Sheet3").Range(Cells(1, 1).Cells(counter, 2))), Gallery:=xlXYScatter, Format:=3, PlotBy:=xlColumns, HasLegend:=True, Title:=CustomerQueue, CategoryTitle:=Time, ValueTitle:=NumberofCustomers)

Thanks


Posted by Juan Pablo G. on January 18, 2002 7:02 AM

Try removing the parenthesis after ChartWizard and then the final one after NumberofCustomers.

VBA is picky on those.

Juan Pablo G.