Excel Programming

Sometimes it would be useful to be able to use cells to select items in a PivotTable. For example, let's say we have a PivotTable containing a field called Region. Instead of using the filter dropdown to select the region from a list it would be nice Read More...

As well as C/C++ and VBA, I'll be blogging a lot about managed code. So I figured it would be useful to lay out the basics of how Excel and managed code interoperate today. If you write Excel addins you’ve probably seen articles like this one that show Read More...

<Fanfare>Hello. My name is Gabhan and this is my new blog dedicated to Excel Programming.</Fanfare> I work as a Program Manager on the Excel product team and I thought it would be useful/fun/exciting to dedicate a blog to programming with Read More...