Hello Everybody,

Newbie Excel vba user (and poster).
I actually have three simple questions, please
The first is as per the title. I have used this construct because I have mixed data types (dates, strings, singles etc) and I believe they do not fit an array. So how do you select an element from this construct? Or does it have an auto index or similar?
Second question: How do you call an excel formula with vba? Eg Linest(y's, x's) is it:
some variable = xlLinest(range, range)?

Third question: Ranges?
If I have Dates and Sales as two elements of my Type construct (above q1) and I want to linear regress Sales against dates (above q2) how do I set up the ranges (y's and x's)

I thank all assisters in advance. My attempts at getting this info from help files and google queries was not much help. So in desperation I turn to the electronic manual and experience
Regards
Murray