Hi,

I am trying to create an instance of a user defined class within a worksheet (Excel VBA) such that I can use the class variables as a cache for a large amout of data.

I have tried:

Public myClass as CMyClass
--------------------------
Public Sub load()

Set myClass = new CMyClass

End sub

public sub load()

myClass.callLoaderFunction()

end sub

But i get a "type mismatch - error 13" when I try and call the load() function.

Any ideas?