I would like to use a range but rather than the values for the elements being in cells A1:A4 for example, they are scattered about the sheet, for example A1, B3, D7, E10.

I am looking for a formula that will produce something equivalent to =A1:A4, for example =createrange(A1, B3, D7, E10)

Many thanks in advance.

Max