cell addres n formulas

  • Thread starter Thread starter Latin Seminary
  • Start date Start date
L

Latin Seminary

Hi,
I am using relative cell address in formulas. Ex: =+F50+I50+M50 ...
I have 108 columns.
When I erased colomns I have an error: #REF!
I tried using obsolute reference without success
=$G$7+$I$7+#REF!+#REF!+$L$7

How can I avoid this error without editing the formula manulay to delete the
#REF!

Khalil
 
Hi Khalil

=INDIRECT("F50")+INDIRECT("I50")+...
assuming that you want the previous J50 to be the new I50 after deleting I.
If you just want it to go away then I believe you need a macro to clean the
formulas up.

HTH. Best wishes Harald
 
Back
Top