Why store the recordset in an array? You are aware that a recordset is an object array of rows already right?

I would just dim the recordset at the class level and work with that, should be easier and faster.