http://blogs.technet.com/b/the_microsoft_excel_support_team_blog/archive/2012/02/16/how-to-display-pivot-table-methods-and-properties-in-vba-intellisense.aspxWhen 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, howeveren-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)http://blogs.technet.com/b/the_microsoft_excel_support_team_blog/archive/2012/02/16/how-to-display-pivot-table-methods-and-properties-in-vba-intellisense.aspx#3561357Wed, 27 Mar 2013 15:46:48 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3561357VISQL<p>Thank you for this tip. I&#39;m learning VBA, and since everything is an object, the big question is always &quot;What can &nbsp;the object do?&quot;</p> <div style="clear:both;"></div><img src="http://blogs.technet.com/aggbug.aspx?PostID=3561357" width="1" height="1">