N
N
Nikita Kochetkov2015-05-18 19:18:26
Visual Basic
Nikita Kochetkov, 2015-05-18 19:18:26

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

2 answer(s)
R
rosperitus, 2015-05-18
@fiercekilla

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

R
Roman Voronov, 2015-05-21
@Rioran

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 question

Ask a Question

731 491 924 answers to any question