Cell number in range

[allenz0rz]

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!

[Ron Coderre]

Using your posted scenario
and
A1: a number between 1 and 144, inclusive

This VBA User Defined Function returns the cell address referenced by cell A1

Please Login or Register  to view this content.

Use that function this way on the sheet with the range:

Please Login or Register  to view this content.

Is that something you can work with?

[allenz0rz]

Perfect! Thank's a lot!