View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul Smith[_4_] Paul Smith[_4_] is offline
external usenet poster
 
Posts: 3
Default PivotTable Columns


Is there anyway to order the columns that appear in a PivotTable?

At present, I am not building the PivotTable with code, and the column
order appears to be determined by the order in which different values
are arrived at as the table is built, moving down the Excel list. I
would like to control the order in which my columns.

Does this require code and if so could anyone give me some clues on what
object to reasearch.

Paul Smith


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!