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?
|