Pivot Table version for Excel 2016 (vba)

[Forestq]

HI,

into below code I'm set up pivot version depon on Excel version.


Do you know what is pivot Table version for excel 2016?

Function pivotTableVersion()
On Error Resume Next

Select Case Application.Version
Case "9.0"
    pivotTableVersion = 0 'excel 2000
Case "10.0"
    pivotTableVersion = 1 'excel 2002
Case "11.0"
    pivotTableVersion = 2 'excel 2003
Case "12.0"
    pivotTableVersion = 3 'excel 2007
Case "14.0"
    pivotTableVersion = 4 'excel 2010#
Case "15.0"
    pivotTableVersion = 5 'excel 2010
End Select

End Function

 

[wideboydixon]

In my copy of Excel 2016 it's coming up as version 6.

WBD