Have you tried absolute references to lock it
$a$1 will stay as a1

--
Don Guillett
SalesAid Software

"Lawlera" wrote in message
...
I have several sheets reading the value from a single cell.
Trouble is that is a row or column is inserted all the referencing is
thrown out the window!
Naming the cell seems to be the answer but having difficulty with the
syntax for reading the cell using
' reference:-"cellname" '

Grateful for any ideas that don't include goto or select!

TIA