| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Omit page with no data when use "show page"
I have a VBA to "show page" by user email at a pivot table. However, some of
them are "empty" and without data, how to omit/ delete those worksheets without data? Sheets("AllData").Select ActiveSheet.PivotTables("PivotTable1").ShowPages PageField:="User email" |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I use Page Break Preview without seeing "PAGE" in sheet? | Excel Discussion (Misc queries) | |||
| Are the "page setup" layout settings overwritten by page preview adjustments ? | Excel Discussion (Misc queries) | |||
| How do I lighten the word "Page" (and number) in Page Break View? | Excel Discussion (Misc queries) | |||
| How do you get "Show Page" functionality in MSExcel PivotTables | Excel Discussion (Misc queries) | |||
| "Can't shift excess data off page"??? | Excel Programming | |||
Threaded Mode
