Thread: Pivot create
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jesse[_4_] Jesse[_4_] is offline
external usenet poster
  
Posts: 15
Default Pivot create
Can anyone help me figure out why this line of code does not work?

ActiveWorkbook.PivotTableWizard SourceType:=xlDatabase,
SourceData:=Sheets("BDData").UsedRange,
tabledestination:=Sheets("BD").Cells(1, 5), tablename:="BDPivot"


Jesse


Reply With QuoteReply With Quote