VBA – Excel – Reference list

Great page on referencing pivot table ranges – shows the range selected for each selection method used
http://www.globaliconnect.com/excel/index.php?option=com_content&view=article&id=154:referencing-an-excel-pivot-table-range-using-vba&catid=79&Itemid=475

Excel Chart Enumeration  (numbering used for each of the different chart types):

https://msdn.microsoft.com/en-us/library/bb241008%28v=office.12%29.aspx?f=255&MSPPError=-2147217396

Good resource for Ribbon controls though it is aimed at Access rather than Excel

http://www.accessribbon.de/en/?Access_-_Ribbons

Leave a Reply

Your email address will not be published.