deleting rows and gettin #REF in formula

  • Thread starter Thread starter Todd
  • Start date Start date
T

Todd

Hi, I several columns of formulas that refer to each
other. When I delete a column I get #ref in the remaining
cells. How do I avoid this?

TIA


Todd
 
Todd,

Not meaning to be snarky, but don't delete the cell references.

If B1 refers to A1 and your delete row A, the old B is now the new A and
the new A contains #ref.

You need to either adjust your formulas prior to deleting (or after, but is
sometimes more difficult), or you must be careful in what you delete.

Regards,
Kevin
 
use edit replace

replace what =

replace with ZZZ=

delete the column

reverse the edit replace
 
Thanks, it worked!
-----Original Message-----
use edit replace

replace what =

replace with ZZZ=

delete the column

reverse the edit replace

--
Regards,
Tom Ogilvy




.
Click to expand...
 
Back
Top