I have a type:

Public Type autoPivotCreationType
clicks As Integer ' Integer variable stores clicks.
campaignName As String ' String variable stores campaign name.
jobName As String ' String variable stores job name.
strategyName As String ' String variable stores strategy name.
dateTime As String ' Date variable stores the date of a transaction.
isEmpty As Boolean
End Type


I want this to be dynamic where I can add subcategories within the type. For Example:

Public Type autoPivotCreationType
isEmpty As Boolean 'isEmpty being a constant paramater within this type
End Type

and then I can add other subtypes later... or somehow create the dynamic subs when creating a variable of autoPivotCreationType.

Like:

Dim arrayForTopTen(10) As autoPivotCreationType
and being able to somehow set stuff like:

arrayForTopTen(1).test = ""
arrayForTopTen(1).someOtherNewField = ""

Ok... hope this makes some sort of sense. Thanx in advance for teh help.

-cLocKwOrk