Hello Stephen,

It's seems to me you would be better off placing this code into a VBA
Module instead of a Class Module. Class modules are used to create in
process server objects. What you are attempting is a regular macro.

You should explore the User Type construct and Collection objects.
These are most likely what you are really after. Your code needs to be
revamped, but without knowing the original objectives that's not
possible.


--
Leith Ross


------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=478593