Array and Collection Functions

These collection functions used worksheets like object collections, providing persistence. Some similar code used classes to wrap worksheet information to provide type-ahead, instead of using arrays via numbers.

Collection Functions

  • IsInCollection
  • SortCollection
  • BuildRowCollection
  • BuildCollectionFromRange
  • BuildRowCollectionFromRange
  • BuildRowCollectionFromWorksheet
  • ReturnValueFromCollectionOfRows

Array Functions

  • UniqueItems
  • TransposeArray

Code link: [System_CommonArrayFunctions.txt]

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