Hi Simon,

Try something like

MsgBox Range("myrange").Value

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Simon Sunke" wrote in message
...
Hello

I need to access a certain cell in a worksheet, but I don't know the
coordinates (row,col = because it may be moved when inserting rows or
cols).
So I tried to name that cell, but now I don't know how to access that
named
cell from the macro code.

Can anybody help me?
Thanks!
Simon Sunke