Hi there,

I would like to create an array of addresses based on adding the values in a range to a string. Excel resolves the array to a single value and returns a single address, rather than an array of addresses.

Given:

A_Range_of_Values = {2,4,5,6}

I would like:

{="SomeSheetName!A" & A_Range_of_Values}

To return:

{SomeSheetName!A2,SomeSheetName!A4,SomeSheetName!A5,SomeSheetName!A6}

Instead of:

SomeSheetName!A2


Any help with this or suggestions of a different approach would be appreciated.

Thanks folks,

Jason.