An Excel Programmability blog by Gabhan Berry
Translate This Page
Translate this page
Browse by Tags
Tagged Content List
Using Custom Functions in Dynamic Ranges
Named ranges are great. They enable us to assign a name to a collection of cells and use that name in code and worksheet functions. However, named ranges tend to be static. That is, they tend to represent a fixed set of cells, such as, A1:E100. But sometimes it would be useful to have the range's set...
19 Feb 2008
Creating Custom Calculated Members and Sets in OLAP PivotTables
If you are using PivotTables against an OLAP data source you may find it useful to be able to create your own custom, calculated measures and sets. These calculations are client-side meaning they exist inside Excel and you don't have to change the server-side OLAP cube. Excel does not enable you to...
6 Feb 2008
MSDN Code Gallery
We have recently launched a code sharing community web site called MSDN Code Gallery . MSDN Code Gallery hosts code snippets and entire projects that have been shared with the community. You can publish your own code or search for and download other peoples' code. There are lots of nice features...
5 Feb 2008
Using Cell Text to Filter PivotTables
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 if we could use a cell to specify the region. That...
31 Jan 2008
Page 1 of 1 (4 items)
© 2015 Microsoft Corporation.
Privacy & Cookies