myvar = Range("my_name").Value

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"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