View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
abajo abajo is offline
external usenet poster
 
Posts: 1
Default Code not working in Excel 2007


Any Idea why the following macro code returns this error:
"Run-time error '1004': Sort Method of Range Class failed". The code works
fine in Office Excel 2003.

ActiveSheet.PivotTables(pivName).PivotSelect "month[All]", xlLabelOnly
Selection.Sort Order1:=xlAscending, Type:=xlSortLabels,
OrderCustom:=csort, Orientation:=xlTopToBottom

Thanks,