I don't think this exists but some of you may have a way around the problem.

I need to create a DB table like structure in memory, I was thinking about an array of UDTs which would be perfect but at design time I won't know the structure.

eg the user may specify the "Table" like structure to have two string fields and three integer fields. This structure won't need to change during the life of the program but I need to create this memory structure temporarily.

I was playing with cell objects in row objects but it was messy and briefly tried reDim varients with a new type but I won't know how many columns I need.

I'd really rather not settle for an array of varient arrays, that would not be good.

There must be a way of defining a memory structure at run time like you can at design time...

Any ideas?