If you named the cell "QQQ", then in VBA:

Sub a()

Range("QQQ") = 123

MsgBox Range("QQQ")

End Sub

--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"



"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