=indirect("M"&a1)
if A1 contained N)

In code:
dim N as long
msgbox activesheet.range("M"&n).value
'or
msgbox activesheet.cells(n,"M").value



john wrote:

How can I designate in a formula a cell regarding to a variable (e.g.
M(value of n) is the cell M535 if n=535 )
thank you ,
John

--

Dave Peterson