hello
when I name a formula (insert/name/define) then I build the formula it remembers it as absolute references.
eg if I am in A3 and I name a formula addthese then build =A1+A2 it creates this text
='Sheet1'!$A$1+'Sheet1'!$B$1
At the moment I have to then edit the text to remove the $ signs.
can I automatically make the reeference relative?
thanks kd
when I name a formula (insert/name/define) then I build the formula it remembers it as absolute references.
eg if I am in A3 and I name a formula addthese then build =A1+A2 it creates this text
='Sheet1'!$A$1+'Sheet1'!$B$1
At the moment I have to then edit the text to remove the $ signs.
can I automatically make the reeference relative?
thanks kd