I am with you on this one. Classes are great for events but otherwise not too
handy in Excel. The UDT is a great tool. It has much less overhead than a
class. The only draw back is that a UDT can not have methods.
--
HTH...

Jim Thomlinson


"Vacation's Over" wrote:

Are there any significant disadvantages to using a user defined type instead
of a class module?

I know that Classes are more portable but seems that the two are
interchangeable in many instances and it takes less code to use Type. So for
one off solutions I tend to lean towards a user defined type and was just
wondering if there was any big issue I was missing.