View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default 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?