Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
pivot field definition in VBA
How can I get VBA to figure out what is in position 1 or 2 or whatever of the
rows in a table? In other words, when I am recording a macro and, for example, dragging out a row field, the recording takes the actual name of that field and makes it invisible. But if I am in a situation where a user is going to be manipulating this and I want Excel to automatically take out, say, the second grouping of a table, without my knowing ahead of time what that second grouping will be at the time the macro is run, then how do I tell it "drag out whatever field is in position 2"? Thx. -- Boris |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
pivot field definition in VBA
Boris, try:
ActiveSheet.PivotTables("SalesPvt").ColumnFields(2 ).Orientation = xlHidden -- HTH Roger Shaftesbury (UK) "BorisS" wrote in message ... How can I get VBA to figure out what is in position 1 or 2 or whatever of the rows in a table? In other words, when I am recording a macro and, for example, dragging out a row field, the recording takes the actual name of that field and makes it invisible. But if I am in a situation where a user is going to be manipulating this and I want Excel to automatically take out, say, the second grouping of a table, without my knowing ahead of time what that second grouping will be at the time the macro is run, then how do I tell it "drag out whatever field is in position 2"? Thx. -- Boris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I remove a Calculated Field from the Pivot Table field list | Excel Discussion (Misc queries) | |||
Pivot Field in Field List but Not Source Data | Excel Discussion (Misc queries) | |||
How to make a field created a part of the Pivot Table Field List? | Excel Discussion (Misc queries) | |||
Unable to change field settings in calculated field in a pivot tab | Excel Discussion (Misc queries) | |||
pivot row field definition in VBA | Excel Programming |