This user defined type is an array. Ubound works normally on this if it is
intialized, but since it's not been intialized, how do I test that?

"Chip Pearson" wrote:

UBound is used only for arrays, not user defined types.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"jayklmno" wrote in message
...
When I check an element, like ubound() I get a subscript error
and it tells
me ubound(UDT) = nothing.

Is there a way to phrase the ubound statement that won't bomb
out the code?

"Tom Ogilvy" wrote:

You would have to check the individual elements I would think.

a UDT is not an object, so is nothing wouldn't work.

--
Regards,
Tom Ogilvy



"jayklmno" wrote:

I have a user defined type that is not getting initialized
under a certain
procedure and when it gets to a point, I need to check and
see if it has been
initialized. I acnnot get any combination of Is Nothing,
IsNull or anything
else I can think of to get it to discover if the UDT =
Nothing.

Any suggestions?