Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Preserve formatting setting in VBA crashing Excel
When I use the following peices of code together they
crash Excel saying "Method CurrentPage of object PivotField failed", and then when I close Excel it crashes. ActiveWorkbook.Worksheets(wkSheet.Name).PivotTable s (pvtTable.Name) _ .PreserveFormatting = True ActiveWorkbook.Worksheets(wkSheet.Name).PivotTable s (pvtTable.Name) _ .PivotFields("Line").CurrentPage = sStr But when I just use either one on its own its fine. Any ideas? Thanks, Grant. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Preserve cell formatting as SSN | Excel Discussion (Misc queries) | |||
Resize chart and preserve formatting (Excel 2007) | Charts and Charting in Excel | |||
How can I concatenate a number and preserve the formatting? | Excel Worksheet Functions | |||
How to preserve formatting with vlookup | Excel Discussion (Misc queries) | |||
Preserve Formatting of pivot table crashing | Excel Programming |