Right now, I have a vba application that draws a tab based on a series of values that are already in memory. It works just fine, however, the act of creating the tabs from the aforementioned MDX queries is not as fast as I think it could be if it were a class object .

Is there an effective manner to create a class module that creates a worksheet when instantiated and assigns values/formulas ? How does this work? It seems like it should be faster.. but that is why I am asking.

If it is, how do I approach this?

I have experience in c++/java from way back in object orientated programming but I am rusty.

Right now the tab creation and drawing process takes about 2 seconds per tab and is 76R by 29C. I would like to cut that in half or less.

To recap, the goal is to do the following:

1. Associate and apply values from a 3 dimensional array to a class object
2. Class object instantiation results in creation of new, named workbook tab
3. Do it fast

Thanks

Also, I have searched extensively and I am just not finding anything from which I can build.