You'd better read Max's post again, Susy.
--
David Biddulph
"susy" wrote in message
...
Let me see if I understood,
my Formula is for example C1=A1/1.82 if I write =("A1")/1.82 it will
always
refer to cell A1?
Because If it is like that I've already try it and is not working. it
saidf
#VALUE!
help pls
susy
"Max" wrote:
please tell me how do I keep the link to the cell A1 if I copy or move
values from A1 to B1? Without getting #REF!,....
In say, C2: =INDIRECT("A1")
instead of: =A1
will always point to cell A1
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"susy" wrote:
Hi my name susy,
I'm working on a finacial structure("balance") which I will have to
lock for
otheruser. but my formulas keep changing if a move, copy or paste a
value in
the worksheet.
please tell me how do I keep the link to the cell A1 if I copy or move
values from A1 to B1? Without getting #REF!,....
because every time I add rows or move some data I have to fix most of
my
formulas.