Run Time Error 5 (Excel 2013 Compatibility Issues?)

[TeachMeEverything]

Hello,

I created a macro for my work that seems to be working just fine, until a different version of excel gets to it. The Macro was created in Excel 2013 but when its ran in 2010 it hits a runtime error 5 message. Is it something with the coding or is it a compatibility issue?

The macro is pretty brute as I recorded most of it with the recorder and fine tuned using this website to teach me some things. Hoping to learn a lot more as I go but this one stumped me, is there a known compatibility issue for these two versions?

 

[hippiehacker]

a code snippet where it hangs would be fine

 

[TeachMeEverything]

Ill reach out and get one, its from a remote user, thanks in advance.

 

[TeachMeEverything]

Thanks again,

Sub InvClick()
'
' InvClick Macro
'

'
Range("E1").Select
ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _
"OnHandData!R1C1:R20000C16", Version:=xlPivotTableVersion15).CreatePivotTable _
TableDestination:="Inventory!R1C1:R1C9", TableName:="PivotTable4", _
DefaultVersion:=xlPivotTableVersion15

 

[hippiehacker]

Backwards compatibility issue define another xlpivottabelversion get here the list
https://msdn.microsoft.com/en-us/li...cel.xlpivottableversionlist(v=office.15).aspx

15 is only for 2013

 

[TeachMeEverything]

Thank you but im still getting the run time 5 error...


Sub InvClick()
'
' InvClick Macro
'

'
Range("E1").Select
ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _
"OnHandData!R1C1:R20000C16", Version:=xlPivotTableVersionCurrent).CreatePivotTable _
TableDestination:="Inventory!R1C1:R1C9", TableName:="PivotTable4", _
DefaultVersion:=xlPivotTableVersionCurrent
Sheets("Inventory").Select
Cells(1, 1).Select


Can you help me figure out what I am doing incorrectly?