Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help: Compile error: type mismatch: array or user defined type expected | Excel Programming | |||
"User-defined type not defined" message in Excel | Excel Discussion (Misc queries) | |||
Workspace faux user-defined type not defined | Excel Programming | |||
User-defined data type; Error: Only User-defined types... | Excel Programming | |||
Word.Document - user defined type not defined | Excel Programming |