Display pivot table data in userform

thousand

New member
Joined
Apr 2, 2017
Messages
30
Reaction score
0
Points
0
Excel Version(s)
2010
I currently have this vba which works perfectly displaying data from pivot table. However, this only works when there are less than 32 columns.
Is there a way to display pivot table data but only for specific columns.

Thanks in advance
Private Sub Workbook_NewSheet(ByVal Sh As Object)
If ActiveSheet.Name <> "worksheetname" Then
ActiveSheet.ShowDataForm
End If
End Sub
 
Back
Top