Search notes:

Office Object Model: Excel - WorksheetFunction

The WorksheetFunction object allows to access the worksheet functions from Visual Basic for Applications.

Applying on a range

The following example applies the three functions min, sum and avg (average) on the values of the cells specified by a range object. 
option explicit

sub main() ' {

    dim val as double

    dim wsf as worksheetFunction : set wsf = application.worksheetFunction
    dim rng as range             : set rng = range("a1:b5")

    fillTestData

    val = wsf.min    (rng) : debug.print "min = " & val
    val = wsf.sum    (rng) : debug.print "sum = " & val
    val = wsf.average(rng) : debug.print "avg = " & val

end sub ' }

sub fillTestData() ' {

    cells(1, 1) =  9: cells(1, 2) =  5
    cells(2, 1) =  2: cells(2, 2) =  8
    cells(3, 1) =  4: cells(3, 2) =  7
    cells(4, 1) =  5: cells(4, 2) =  5
    cells(5, 1) =  3: cells(5, 2) =  4

end sub ' }
Github repository about-MS-Office-object-model, path: /Excel/WorksheetFunction/intro.bas
Compare with calling function on the Application object.

Index of functions found in the WorksheetFunction object

The following functions were found in PowerShell with something like 
$excel = [System.Runtime.InteropServices.Marshal]::GetActiveObject('Excel.Application')
$excel.WorksheetFunction | gm -type method
Some functions, such as cell(), address() or upper(), that can be used in a cell, were not found with this PowerShell construct.
Name Return type
AccrInt double (Variant, Variant, Variant, Variant, Variant, Variant, Variant)
AccrIntM double (Variant, Variant, Variant, Variant, Variant)
Acos double (double)
Acosh double (double)
Acot double (double)
Acoth double (double)
Aggregate double (double, double, Range, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Va...
AmorDegrc double (Variant, Variant, Variant, Variant, Variant, Variant, Variant)
AmorLinc double (Variant, Variant, Variant, Variant, Variant, Variant, Variant)
And bool (Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Varian...
Arabic double (string)
Asc string (string)
Asin double (double)
Asinh double (double)
Atan2 double (double, double)
Atanh double (double)
AveDev double (Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, V...
Average double (Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, ...
AverageIf double (Range, Variant, Variant)
AverageIfs double (Range, Range, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, V...
BahtText string (double)
Base string (double, double, Variant)
BesselI double (Variant, Variant)
BesselJ double (Variant, Variant)
BesselK double (Variant, Variant)
BesselY double (Variant, Variant)
BetaDist double (double, double, double, Variant, Variant)
BetaInv double (double, double, double, Variant, Variant)
Beta_Dist double (double, double, double, bool, Variant, Variant)
Beta_Inv double (double, double, double, Variant, Variant)
Bin2Dec string (Variant)
Bin2Hex string (Variant, Variant)
Bin2Oct string (Variant, Variant)
BinomDist double (double, double, double, bool)
Binom_Dist double (double, double, double, bool)
Binom_Dist_Range double (double, double, double, Variant)
Binom_Inv double (double, double, double)
Bitand double (double, double)
Bitlshift double (double, double)
Bitor double (double, double)
Bitrshift double (double, double)
Bitxor double (double, double)
Ceiling double (double, double)
Ceiling_Math double (double, Variant, Variant)
Ceiling_Precise double (double, Variant)
ChiDist double (double, double)
ChiInv double (double, double)
ChiSq_Dist double (double, double, bool)
ChiSq_Dist_RT double (double, double)
ChiSq_Inv double (double, double)
ChiSq_Inv_RT double (double, double)
ChiSq_Test double (Variant, Variant)
ChiTest double (Variant, Variant)
Choose Variant (Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, ...
Clean string (string)
Combin double (double, double)
Combina double (double, double)
Complex string (Variant, Variant, Variant)
Concat string (string, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Va...
Confidence double (double, double, double)
Confidence_Norm double (double, double, double)
Confidence_T double (double, double, double)
Convert double (Variant, Variant, Variant)
Correl double (Variant, Variant)
Cosh double (double)
Cot double (double)
Coth double (double)
Count double (Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Va...
CountA double (Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, V...
CountBlank double (Range)
CountIf double (Range, Variant)
CountIfs double (Range, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, V...
CoupDayBs double (Variant, Variant, Variant, Variant)
CoupDays double (Variant, Variant, Variant, Variant)
CoupDaysNc double (Variant, Variant, Variant, Variant)
CoupNcd double (Variant, Variant, Variant, Variant)
CoupNum double (Variant, Variant, Variant, Variant)
CoupPcd double (Variant, Variant, Variant, Variant)
Covar double (Variant, Variant)
Covariance_P double (Variant, Variant)
Covariance_S double (Variant, Variant)
CritBinom double (double, double, double)
Csc double (double)
Csch double (double)
CumIPmt double (Variant, Variant, Variant, Variant, Variant, Variant)
CumPrinc double (Variant, Variant, Variant, Variant, Variant, Variant)
DAverage double (Range, Variant, Variant)
Days double (Variant, Variant)
Days360 double (Variant, Variant, Variant)
Db double (double, double, double, double, Variant)
Dbcs string (string)
DCount double (Range, Variant, Variant)
DCountA double (Range, Variant, Variant)
Ddb double (double, double, double, double, Variant)
Dec2Bin string (Variant, Variant)
Dec2Hex string (Variant, Variant)
Dec2Oct string (Variant, Variant)
Decimal double (string, double)
Degrees double (double)
Delta double (Variant, Variant)
DevSq double (Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Va...
DGet Variant (Range, Variant, Variant)
Disc double (Variant, Variant, Variant, Variant, Variant)
DMax double (Range, Variant, Variant)
DMin double (Range, Variant, Variant)
Dollar string (double, Variant)
DollarDe double (Variant, Variant)
DollarFr double (Variant, Variant)
DProduct double (Range, Variant, Variant)
DStDev double (Range, Variant, Variant)
DStDevP double (Range, Variant, Variant)
DSum double (Range, Variant, Variant)
Dummy19 Variant (Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant,...
Dummy21 double (double, double)
Duration double (Variant, Variant, Variant, Variant, Variant, Variant)
DVar double (Range, Variant, Variant)
DVarP double (Range, Variant, Variant)
EDate double (Variant, Variant)
Effect double (Variant, Variant)
EncodeURL Variant (string)
EoMonth double (Variant, Variant)
Erf double (Variant, Variant)
ErfC double (Variant)
ErfC_Precise double (Variant)
Erf_Precise double (Variant)
Even double (double)
ExponDist double (double, double, bool)
Expon_Dist double (double, double, bool)
Fact double (double)
FactDouble double (Variant)
FDist double (double, double, double)
FieldValue Variant (Variant, string)
Filter Variant (Variant, Variant, Variant)
FilterXML Variant (string, string)
Find double (string, string, Variant)
FindB double (string, string, Variant)
FInv double (double, double, double)
Fisher double (double)
FisherInv double (double)
Fixed string (double, Variant, Variant)
Floor double (double, double)
Floor_Math double (double, Variant, Variant)
Floor_Precise double (double, Variant)
Forecast double (double, Variant, Variant)
Forecast_ETS double (double, Variant, Variant, Variant, Variant, Variant)
Forecast_ETS_ConfInt double (double, Variant, Variant, Variant, Variant, Variant, Variant)
Forecast_ETS_Seasonality double (Variant, Variant, Variant, Variant)
Forecast_ETS_STAT double (Variant, Variant, double, Variant, Variant, Variant)
Forecast_Linear double (double, Variant, Variant)
Frequency Variant (Variant, Variant)
FTest double (Variant, Variant)
Fv double (double, double, double, Variant, Variant)
FVSchedule double (Variant, Variant)
F_Dist double (double, double, double, bool)
F_Dist_RT double (double, double, double)
F_Inv double (double, double, double)
F_Inv_RT double (double, double, double)
F_Test double (Variant, Variant)
Gamma double (double)
GammaDist double (double, double, double, bool)
GammaInv double (double, double, double)
GammaLn double (double)
GammaLn_Precise double (double)
Gamma_Dist double (double, double, double, bool)
Gamma_Inv double (double, double, double)
Gauss double (double)
Gcd double (Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Vari...
GeoMean double (Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, ...
GeStep double (Variant, Variant)
Growth Variant (Variant, Variant, Variant, Variant)
HarMean double (Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, ...
Hex2Bin string (Variant, Variant)
Hex2Dec string (Variant)
Hex2Oct string (Variant, Variant)
HLookup Variant (Variant, Variant, Variant, Variant)
HypGeomDist double (double, double, double, double)
HypGeom_Dist double (double, double, double, double, bool)
IfError Variant (Variant, Variant)
IfNa Variant (Variant, Variant)
ImAbs string (Variant)
Imaginary double (Variant)
ImArgument string (Variant)
ImConjugate string (Variant)
ImCos string (Variant)
ImCosh string (Variant)
ImCot string (Variant)
ImCsc string (Variant)
ImCsch string (Variant)
ImDiv string (Variant, Variant)
ImExp string (Variant)
ImLn string (Variant)
ImLog10 string (Variant)
ImLog2 string (Variant)
ImPower string (Variant, Variant)
ImProduct string (Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant...
ImReal double (Variant)
ImSec string (Variant)
ImSech string (Variant)
ImSin string (Variant)
ImSinh string (Variant)
ImSqrt string (Variant)
ImSub string (Variant, Variant)
ImSum string (Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Va...
ImTan string (Variant)
Index Variant (Variant, double, Variant, Variant)
Intercept double (Variant, Variant)
IntRate double (Variant, Variant, Variant, Variant, Variant)
Ipmt double (double, double, double, double, Variant, Variant)
Irr double (Variant, Variant)
IsErr bool (Variant)
IsError bool (Variant)
IsEven bool (Variant)
IsFormula bool (Range)
IsLogical bool (Variant)
IsNA bool (Variant)
IsNonText bool (Variant)
IsNumber bool (Variant)
IsOdd bool (Variant)
IsoWeekNum double (double, Variant)
ISO_Ceiling double (double, Variant)
Ispmt double (double, double, double, double)
IsText bool (Variant)
IsThaiDigit bool (string)
Kurt double (Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Var...
Large double (Variant, double)
Lcm double (Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Vari...
LinEst Variant (Variant, Variant, Variant, Variant)
Ln double (double)
Log double (double, Variant)
Log10 double (double)
LogEst Variant (Variant, Variant, Variant, Variant)
LogInv double (double, double, double)
LogNormDist double (double, double, double)
LogNorm_Dist double (double, double, double, bool)
LogNorm_Inv double (double, double, double)
Lookup Variant (Variant, Variant, Variant)
Match double (Variant, Variant, Variant)
Max double (Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Vari...
MaxIfs double (Range, Range, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Varia...
MDeterm double (Variant)
MDuration double (Variant, Variant, Variant, Variant, Variant, Variant)
Median double (Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, V...
Min double (Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Vari...
MinIfs double (Range, Range, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Varia...
MInverse Variant (Variant)
MIrr double (Variant, double, double)
MMult Variant (Variant, Variant)
Mode double (Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Var...
Mode_Mult Variant (Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Varian...
Mode_Sngl double (Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant...
MRound double (Variant, Variant)
MultiNomial double (Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Varia...
Munit Variant (double)
NegBinomDist double (double, double, double)
NegBinom_Dist double (double, double, double, bool)
NetworkDays double (Variant, Variant, Variant)
NetworkDays_Intl double (Variant, Variant, Variant, Variant)
Nominal double (Variant, Variant)
NormDist double (double, double, double, bool)
NormInv double (double, double, double)
NormSDist double (double)
NormSInv double (double)
Norm_Dist double (double, double, double, bool)
Norm_Inv double (double, double, double)
Norm_S_Dist double (double, bool)
Norm_S_Inv double (double)
NPer double (double, double, double, Variant, Variant)
Npv double (double, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Varia...
NumberValue double (string, string, string)
Oct2Bin string (Variant, Variant)
Oct2Dec string (Variant)
Oct2Hex string (Variant, Variant)
Odd double (double)
OddFPrice double (Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant)
OddFYield double (Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant)
OddLPrice double (Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant)
OddLYield double (Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant)
Or bool (Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant...
PDuration double (double, double, double)
Pearson double (Variant, Variant)
Percentile double (Variant, double)
Percentile_Exc double (Variant, double)
Percentile_Inc double (Variant, double)
PercentRank double (Variant, double, Variant)
PercentRank_Exc double (Variant, double, Variant)
PercentRank_Inc double (Variant, double, Variant)
Permut double (double, double)
Permutationa double (double, double)
Phi double (double)
Phonetic string (Range)
Pi double ()
Pmt double (double, double, double, Variant, Variant)
Poisson double (double, double, bool)
Poisson_Dist double (double, double, bool)
Power double (double, double)
Ppmt double (double, double, double, double, Variant, Variant)
Price double (Variant, Variant, Variant, Variant, Variant, Variant, Variant)
PriceDisc double (Variant, Variant, Variant, Variant, Variant)
PriceMat double (Variant, Variant, Variant, Variant, Variant, Variant)
Prob double (Variant, Variant, double, Variant)
Product double (Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, ...
Proper string (string)
Pv double (double, double, double, Variant, Variant)
Quartile double (Variant, double)
Quartile_Exc double (Variant, double)
Quartile_Inc double (Variant, double)
Quotient double (Variant, Variant)
Radians double (double)
RandArray Variant (Variant, Variant)
RandBetween double (Variant, Variant)
Rank double (double, Range, Variant)
Rank_Avg double (double, Range, Variant)
Rank_Eq double (double, Range, Variant)
Rate double (double, double, double, Variant, Variant, Variant)
Received double (Variant, Variant, Variant, Variant, Variant)
Replace string (string, double, double, string)
ReplaceB string (string, double, double, string)
Rept string (string, double)
Roman string (double, Variant)
Round double (double, double)
RoundBahtDown double (double)
RoundBahtUp double (double)
RoundDown double (double, double)
RoundUp double (double, double)
Rri double (double, double, double)
RSq double (Variant, Variant)
RTD Variant (Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Var...
Search double (string, string, Variant)
SearchB double (string, string, Variant)
Sec double (double)
Sech double (double)
Sequence Variant (Variant, Variant, Variant, Variant)
SeriesSum double (Variant, Variant, Variant, Variant)
Single Variant (Variant)
Sinh double (double)
Skew double (Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Var...
Skew_p double (Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, V...
Sln double (double, double, double)
Slope double (Variant, Variant)
Small double (Variant, double)
Sort Variant (Variant, Variant, Variant, Variant)
SortBy Variant (Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, ...
SqrtPi double (Variant)
Standardize double (double, double, double)
StDev double (Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Va...
StDevP double (Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, V...
StDev_P double (Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, ...
StDev_S double (Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, ...
StEyx double (Variant, Variant)
Substitute string (string, string, string, Variant)
Subtotal double (double, Range, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Va...
Sum double (Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Vari...
SumIf double (Range, Variant, Variant)
SumIfs double (Range, Range, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Varia...
SumProduct double (Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Varian...
SumSq double (Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Va...
SumX2MY2 double (Variant, Variant)
SumX2PY2 double (Variant, Variant)
SumXMY2 double (Variant, Variant)
Syd double (double, double, double, double)
Tanh double (double)
TBillEq double (Variant, Variant, Variant)
TBillPrice double (Variant, Variant, Variant)
TBillYield double (Variant, Variant, Variant)
TDist double (double, double, double)
Text string (Variant, string)
TextJoin string (string, bool, string, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Vari...
ThaiDayOfWeek string (double)
ThaiDigit string (string)
ThaiMonthOfYear string (double)
ThaiNumSound string (double)
ThaiNumString string (double)
ThaiStringLength double (string)
ThaiYear double (double)
TInv double (double, double)
Transpose Variant (Variant)
Trend Variant (Variant, Variant, Variant, Variant)
Trim string (string)
TrimMean double (Variant, double)
TTest double (Variant, Variant, double, double)
T_Dist double (double, double, bool)
T_Dist_2T double (double, double)
T_Dist_RT double (double, double)
T_Inv double (double, double)
T_Inv_2T double (double, double)
T_Test double (Variant, Variant, double, double)
Unichar string (double)
Unicode double (string)
Unique Variant (Variant, Variant, Variant)
USDollar string (double, double)
Var double (Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Vari...
VarP double (Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Var...
Var_P double (Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Va...
Var_S double (Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Va...
Vdb double (double, double, double, double, double, Variant, Variant)
VLookup Variant (Variant, Variant, Variant, Variant)
WebService Variant (string)
Weekday double (Variant, Variant)
WeekNum double (Variant, Variant)
Weibull double (double, double, double, bool)
Weibull_Dist double (double, double, double, bool)
WorkDay double (Variant, Variant, Variant)
WorkDay_Intl double (Variant, Variant, Variant, Variant)
Xirr double (Variant, Variant, Variant)
Xnpv double (Variant, Variant)
Xor bool (Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Varian...
YearFrac double (Variant, Variant, Variant)
YieldDisc double (Variant, Variant, Variant, Variant, Variant)
YieldMat double (Variant, Variant, Variant, Variant, Variant, Variant)
ZTest double (Variant, double, Variant)
Z_Test double (Variant, double, Variant)
_WSFunction Variant (Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Variant, Vari...

See also

WorksheetFunction.index can be used to extract arrays from arrays.
transpose, for example to write the values of an array vertically into a worksheet.
Excel Object Model

Index