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
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