ExcelMacroandVBARecording/EditingMacroRecordingmacro:Tools/Macro/RecordnewmacroEditingmacro:Tools/Macro/MacrosExcel’smacrosareVBAproceduresLearningVBAwithMacroSpreadsheetoperations:Copy/Paste/Fill/Clear/DeleteFormatcellsAddingaworksheetInsert/Deleterows,mandsData/Sort/mandsRange("A3:F25").SortKey1:=Range("C4"),Order1:=xlAscending,Key2:=Range("B4"),Order2:=xlAscending,Header:=xlGuess,OrderCustom:=1,MatchCase:=False,Orientation:=xlTopToBottom,DataOption1:=xlSortNormal,DataOption2:=:=2,Function:=xlAverage,TotalList:=Array(6),Replace:=True,PageBreaks:=False,SummaryBelowData:=TrueNote:UseExcelObjectModeltostudyRangeobject’sSortandSubtotalmethods.(Selectionreturnsarangeobject)Data/(SourceType:=xlDatabase,SourceData:="Sheet1!R3C1:R24C6").CreatePivotTableTableDestination:="",TableName:="PivotTable2",DefaultVersion:=:=(3,1)(3,1).("PivotTable2").AddFieldsRowFields:="Race",ColumnFields:="Sex"("PivotTable2").PivotFields("Salary").Orientation=="AverageofSalary".Function=’(SourceType,SourceData)SourceType:PivotTableSourceTypecanbeoneoftheseXlPivotTableSourceTypexlDatabasexlExternalSourceData:RequiredifSourceTypeisn',wecancreatearecordsetandassigntherecordsetobjecttopivotCahce’=rstRecordsetPivotCache’(TableDestination,TableName,ReadData,De
Excel Macro and VBA 来自淘豆网m.daumloan.com转载请标明出处.
