Worksheet Wrapper Classes

This is an idea I developed to avoid using arrays while refactoring spaghetti code. The user had used numerous arrays across many sheets with many columns, and for some refactored features I decided to create a parameter class for the rows of select sheets, and then a class that would hold a collection of parameter classes, providing type ahead and methods to get values, as well as provide basic properties like Count and Item.

Code Link: [CPortfolioValues.zip]

Note: Requires an additional helper function contained in [System_CommonArrayFunctions]

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License