run-time error 1004 (Olap code missing)

[Khvleuri]

Hi everyone.

Could you please help me to deal with this error?

I've tried a numerous scenarios to link the variable with the Pivot table field using & and " combinations but with no success

thanks in advance

 

[vletm]

Do Your table really have two times ( .PivotFields ) Line-column?

 

[Debaser]

It would be:
Array("[Report].[Line].&[" & h & "]")

 

[Khvleuri]

Do Your table really have two times ( .PivotFields ) Line-column?

the pivot is created from data module. maybe that should be a reason of this

 

[Khvleuri]

It would be:
Array("[Report].[Line].&[" & h & "]")

wow! I've tried a lot of & and " combination, but your example really solved it. thanks a lot