I know I can iterate through a worksheet collection in Excel. For Example I
can loop through the formulas in a given sheet as follows below. This
collection is already provided by Excel.

For each sht in Thisworkbook.Worksheets
For Each rng1 In sht.UsedRange.SpecialCells(xlFormulas)

Next
Next

1) Is it possible to create custom properties to add to the SpecialCells
property using a class module (i.e. create a custom worksheet class with
custom properties)?

2) In order to create these properties I will have to loop through the
worksheet to build the custom collection (asuming I cannot use a dictionary
object). This can be time consuming depending on what it is you want the
collection to look like. Would it be quicker to build this custom worksheet
Object and its custom collection via C++ using a dll? Or are you forced to
do this within Excel via VBA?

Thanks

EM