Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Type Mismatch error
Hello, I get a type mismatch error with the following
code but can't see where I am going wrong. Can anyone help please? Thanks. For Each pvtTable In ActiveWorkbook.Worksheets _ (wkSheet.Name).PivotTables pvtTable.PreserveFormatting = True Worksheets(wkSheet).PivotTables _ (pvtTable).PivotFields("Line").CurrentPage = str Next pvtTable |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Visual Basic Error Run Time Error, Type Mismatch | Excel Discussion (Misc queries) | |||
Type Mismatch Error | Excel Discussion (Misc queries) | |||
Befuddled with For Next Loop ------ Run - Time Error '13' Type Mismatch Error | Excel Programming | |||
help with type mismatch error | Excel Programming | |||
Type mismatch error | Excel Programming |