Hey all,

If I have a range, let's say myRange = ("B2:M13"), is there anyway to link the cells to a single number, not coordinates?

For example:
B2 would be 1, B3 would be 2, C2 would be 13, M13 would be 144.

This way, I could refer to a cell in the range using something like myRange(1) for 1st cell ** the range.

Thank you so much!