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

Function MyCell(cCell As Range) As String
Dim RowRef As Long
Dim ColRef As Long
Dim rng As Range
Set rng = [$B$2:$M$13]

RowRef = cCell Mod 12
ColRef = Int(cCell / 12) + 1
MyCell = rng.Cells(RowIndex:=RowRef, ColumnIndex:=ColRef).Address

End Function

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

=MyCell(A1)

Is that something you can work with?

[allenz0rz]

Perfect! Thank's a lot!