| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
adding a page break in a pivot table
how can i add a page break before a certain field in a pivot table?? i search around and i tried something like : Dim pf As PivotField For Each pf In ActiveSheet.PivotTables("Tabela dinmica2").PivotFields If (pf = "PETROLEO") Then ActiveWindow.SelectedSheets.HPageBreaks.Add Befo=pf End If Next pf but its not working, it gives me no error message and its not adding a page break .... someone can give me a hand pleasE? -- redf1re ------------------------------------------------------------------------ redf1re's Profile: http://www.excelforum.com/member.php...o&userid=31258 View this thread: http://www.excelforum.com/showthread...hreadid=519480 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
adding a page break in a pivot table
up  -- redf1re ------------------------------------------------------------------------ redf1re's Profile: http://www.excelforum.com/member.php...o&userid=31258 View this thread: http://www.excelforum.com/showthread...hreadid=519480 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
adding a page break in a pivot table
up one more time :( :( :( :( :( -- redf1re ------------------------------------------------------------------------ redf1re's Profile: http://www.excelforum.com/member.php...o&userid=31258 View this thread: http://www.excelforum.com/showthread...hreadid=519480 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
adding a page break in a pivot table
omg... no one can help me??? =[ -- redf1re ------------------------------------------------------------------------ redf1re's Profile: http://www.excelforum.com/member.php...o&userid=31258 View this thread: http://www.excelforum.com/showthread...hreadid=519480 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
adding a page break in a pivot table
im losing hope people, came on :( -- redf1re ------------------------------------------------------------------------ redf1re's Profile: http://www.excelforum.com/member.php...o&userid=31258 View this thread: http://www.excelforum.com/showthread...hreadid=519480 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
adding a page break in a pivot table
maybe another up? -- redf1re ------------------------------------------------------------------------ redf1re's Profile: http://www.excelforum.com/member.php...o&userid=31258 View this thread: http://www.excelforum.com/showthread...hreadid=519480 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 Page Break Adjustments causes a page break each cell | Excel Worksheet Functions | |||
| Pivot Table Data Adding contents of two pivot tables and param que | Excel Discussion (Misc queries) | |||
| Pivot Table Page Break problem | Excel Discussion (Misc queries) | |||
| adding a new page break to an existing page break | Excel Discussion (Misc queries) | |||
| Copy worksheet with Pivot Table and break link to original workshe | Excel Worksheet Functions | |||
![redf1re[_12_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
