Some Worksheet Functions Used Within VBA Create an Array

SOME WORKSHEET FUNCTIONS USED WITHIN VBA CREATE AN ARRAY 

If you use a worksheet function within VBA that returns an array, the lower array index will be 1. Such worksheet functions include LI NEST, TRANSPOSE, MINVERSE, MMULT. Other functions that return arrays include the VBA function Caller when used with a menu command or toolbutton. 

Note that the values in the range of cells have not been transferred to a VBA array the VBA variable simply points to the range on the worksheet. 

---