Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Changing PivotField Summary Stats
Hi Skip, This worked perfectly. I hadn't realized that I could loop through each datafield with the For Each call. My previous macros were explicitly stating the datafield name which could get pretty tedious. Thanks! Carl- heavnstrl
- Post #3
- Forum: Microsoft: Office
-
Changing PivotField Summary Stats
I use pivot tables in Excel XP extensively. When creating the pivot table through the wizard, excel 'automatically' determines how to summarize the data (either SUM or COUNT). I frequently use AVERAGE and have yet to find a way to set a default summarization type. Has anyone found a way to...- heavnstrl
- Thread
- Replies: 2
- Forum: Microsoft: Office
-
Pivot Table source data reference in VBA
Figured out my own question. Adding code as follows fixed the problem: prows = resultsheet.UsedRange.Rows.Count ActiveWorkbook.PivotCaches.add(SourceType:=xlDatabase, SourceData:= _ "Results!A1:AJ" & prows).CreatePivotTable TableDestination:="", TableName:= _...- heavnstrl
- Post #2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Pivot Table source data reference in VBA
I am creating a pivot table in which the data source (on a sheet named "results") has a variable number of rows. I can hard code the number of rows but would prefer to just refer to the 'used range' instead. The statement calling the pivot table currently looks like this...- heavnstrl
- Thread
- Replies: 1
- Forum: VBA Visual Basic for Applications (Microsoft)
