James Burger
New Member
- Joined
- Jun 10, 2014
- Messages
- 31
Hi All,
I have this VBA code line but about 60 of them one below the other and refreshes the pivot after each line I think:
Line 1 - Sheets("Sheet1").PivotTables("PivotTable1").PivotFields("Location").CurrentPage = Sheets("Sheet1").Range("C4").Text
....
Line 60 - Sheets("Sheet1").PivotTables("PivotTable1").PivotFields("Size").CurrentPage = Sheets("Sheet1").Range("C444").Text
Is there a way to turn refresh off before the code is run and then turn it back on at the end of the code please?
Many thanks for your help.
JB
I have this VBA code line but about 60 of them one below the other and refreshes the pivot after each line I think:
Line 1 - Sheets("Sheet1").PivotTables("PivotTable1").PivotFields("Location").CurrentPage = Sheets("Sheet1").Range("C4").Text
....
Line 60 - Sheets("Sheet1").PivotTables("PivotTable1").PivotFields("Size").CurrentPage = Sheets("Sheet1").Range("C444").Text
Is there a way to turn refresh off before the code is run and then turn it back on at the end of the code please?
Many thanks for your help.
JB