Answer the question
In order to leave comments, you need to log in
Expected: expression, where does the VBA compiler error come from?
Throws an error Expected: expression
on a string
Range("F1").DataSeriesRowcol := xlColumns,Type:=xlLinear,Step:=x_шаг,Stop:=x_пз,Trend:=False
Answer the question
In order to leave comments, you need to log in
You assign a bunch of parameters to the property, as if you were calling a function...
Maybe it's better like this - Range("F1").DataSeriesRowcol xlColumns,Type:=xlLinear,Step:=x_step,Stop:=x_pz,Trend:=False
Nikita, hello. There must be a space between the DataSeries
method and its Rowcol argument .
Link to official Microsoft help HERE . Update : I didn't see that rosperitus already mentioned the gap in the comment to his answer.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question