NickHK
12/20/2006 5:28:00 AM
Maybe you could convert your UDT to class and add a method like:
Public Function PrintMe (StartAt as range) As Boolean
with startAt
.Value=Var1
.Offset(0,1).Value=var2
....etc
Or use an array:
Dim MyData(1 to 39) as variant
Depends what you already have/want to do.
NickHK
"jayklmno" <jayklmno@discussions.microsoft.com> wrote in message
news:20659882-4B6D-46C8-B365-2C4E368EF3E0@microsoft.com...
> If I have an UDT of 39 elements, and I want to print this out like a
record
> across columns in a row, is there a way to reference the elements without
> using the name for each?
>
> Is that clear?