Question: what is the difference between an array and a range in excel?
Answer: It may help you to think of a range as as a collection of cells while an array is a collection of values. ... It may help you to think of a range as as a collection of cells while an array is a collection of values.