array and range

[HESH]

What is the array and long?
And what is the difference between the two, is there any fixed rules and parameters for each of them?

 

[Tuelor]

An array is a collection of objects, and a long is a specific object.

You use an array by defining its length and data type. A long variable is one particular data type. If you search vba data type in Google you should find several useful articles going in to more depth.

D

 

[HESH]

i mean range and array in formula not VBA

 

[VoG]

This may help http://www.cpearson.com/excel/ArrayFormulas.aspx or try to be more specific.