Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro skips a command
I have a button that runs the following codle. All of it works as intended
excpet the two lines that attempt to set the column widths of range named 'widthselection' to 18, after the pivot table has been refreshed. Would like some advice, please. Application.DisplayAlerts = False With Sheets("Summaries") .Unprotect Password:="topSecret" Sheets("Summaries").PivotTables("PivotTable2").Piv otCache.Refresh Dim pt As PivotTable Dim ws As Worksheet Dim pc As PivotCache For Each ws In ActiveWorkbook.Worksheets For Each pt In ws.PivotTables pt.PivotCache.MissingItemsLimit = xlMissingItemsNone Next pt Next ws For Each pc In ActiveWorkbook.PivotCaches On Error Resume Next pc.Refresh Next pc Range("widthselection").Select Selection.ColumnWidth = 18 .Protect Password:="topSecret" End With -- cm |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Loop Skips Data - Why? | Excel Programming | |||
skips controls | Excel Programming | |||
Macro deletes row in range, macro then skips the row moved up | Excel Discussion (Misc queries) | |||
How do I set it so my tab key skips to the next cell not 6? | Excel Discussion (Misc queries) | |||
Amortization with up front skips | Excel Worksheet Functions |