These classes provide the tools and data structures needed to separate your physical data in your spreadsheet, from how you process it in your procedures.  Notice that the row and column numbers begin at 1, and are relative to the start of the dataset (not the row/column on the spreadsheet), in order to abstract the cDataset from its physical location. This class is used throughout this site. Here are just a few examples of the projects illustrating its use. You may want to start with How to use cDataSet

cCell Class

cCell Class

  This class addresses and manipulates a single excel cell and its contents.  You can find …
cDataColumn

cDataColumn

Summary This is a column of cCell  . The rowId  argument refers to the row either by row name (wh…
cDataRow

cDataRow

This is a row of cCell  . The sid  argument refers to the column either by column name or …
cDataSet

cDataSet

Summary This is a block of cCell   consisting of a collection of  cDataRow , with an abstraction of …
CDataSets

CDataSets

  Summary   This is a collection of cDataSet You can find the methods an…
cHeadingRow

cHeadingRow

  Summary This is a special type of cDataRow  and is used for managing the column headers of…
Copying and filtering worksheets and Excel tables

Copying and filtering worksheets and Excel tables

What can you learn here? Select worksheets to copy Choose selected columns  cDataSets filtering …
Data Abstraction Example

Data Abstraction Example

Why abstract anyway? In a number of articles on this site and elsewhere, I have covered topics such …

Get Data from Outlook

  How to get data into Excel from your outlook address book  get it now Here’s a common problem. Y…
How to use cDataSet

How to use cDataSet

What can you learn here? Get Started with cDataSet Short code snippets Abbreviated explanations…
cDataSet Model

cDataSet Model

What to download: All the examples contain all the classes needed for them to work and all projects…
Clear data cells with cDataSet

Clear data cells with cDataSet

Hopefully you will have read How to use cDataSet to see how to abstract data from your sheet and taken…
How to make a table from a cdataset

How to make a table from a cdataset

From Excel 2003, you could use Tables. A cDataSet is somewhat like a table in that is structured data,…

Tables and listobjects

Nowadays structured references are the preferred way to access table data in Excel and VBA. Although…

What to download

All the examples contain all the classes needed for them to work and all projects can be found here.
 
If you just want the main utility classes used throughout this site, in the Downloads section cDataSet.xlsm includes everything you need including some examples.
 
All classes have a tearDown method. You can use these to release up any memory when you are done. You  execute this for the highest level class you use, typically a cDataSet, as follows
 
dim ds as cDataSet
set ds=new cDataSet
with ds.populateData(someRange)
   ... do things
end with
ds.tearDown()