User-Defined Type
 

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" wrote in message
...
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?