Macro runs on one computer and get run time error 5 on another

[LenaMWork]

Hello!

I run a macro on one computer and it is fine
And on another it gives me the run time error 5: invalid procedure call or argument

This is the code he doesn`t like:


ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _
Range(Cells(1, 1), Cells(R, C)), Version:=xlPivotTableVersion15).CreatePivotTable _
TableDestination:="ProjectsOW!R3C1", TableName:="PivotTable3", DefaultVersion _
:=xlPivotTableVersion15

Please help!

 

[LenaMWork]

You're welcome.

PS You don't need to quote every comment in your replies or post double replies either!

It was a mistake
I don`t know how to delete comments here