-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
xpfile
-
VBA PivotT filter: Unable to get the pivotfields property of the worksheet class.
Hello friends, Hope all is well! The VB has a bug. Trying to filter a PivotTable with a cell value (CB2). I got the bug: unable to get the pivotfields property of the worksheet class And the following line is highlighted: Set xPFile = xPTable.PivotFields("Month") Your kind & continuous...- countryfan_nt
- Thread
- dim filter set xpfile xstr
- Replies: 3
- Forum: Excel Questions
-
G
Pivot table/chart code has stopped working
I had this code working for my pivot table/chart to update from a drop down list and its stopped working :( Does anyone have any ideas why it has stopped working? Private Sub Worksheet_Change(ByVal Target As Range) 'Update 20190604 Dim xPTable As PivotTable Dim xPFile As PivotField...- gbucko
- Thread
- dim set vba;excel;code; pivot xpfile xstr
- Replies: 0
- Forum: Excel Questions
-
D
Combine 2 codes in VBA
Hi, How can i combine below 2 codes? Also for lookup values i need to combine cells C4&F4. To do is this code makes sense? If Intersect(Target, Target.Worksheet.Range("C4" & "F4")) Is Nothing Then Exit Sub Private Sub Worksheet_Change(ByVal Target As Range) Dim xPTable As PivotTable Dim...- Dokat
- Thread
- combine end intersecttarget set xpfile
- Replies: 3
- Forum: Excel Questions
