When you are coding and use a compact method of referring to a pivot table such as: ActiveSheet.PivotTables(1). You would expect VBA's intellisense to display the methods and properties of the PivotTables collection when adding the period, however...