Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba code for Pivot Table
I have written vba to generate a PT from a list of rows
in excel. I do not want to include in the PT the rows that has a certain key field = zero but they still appear. The key field contains an IF statement that forces the value of one cell into it until an occurence of a condition and then it is to contain zero. I cannot work out how to programmically suppress it while it contains zero. Any ideas |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Pivot Table VB Code | Excel Discussion (Misc queries) | |||
Pivot Table Code | Excel Discussion (Misc queries) | |||
Pivot Table VBA code to move a row | Excel Discussion (Misc queries) | |||
remove the row value in the pivot table creation code. | Excel Programming | |||
HELP! Code for Pivot Table | Excel Programming |