deleting rows and gettin #REF in formula

[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

 

[Kevin Stecyk]

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

 

[Tom Ogilvy]

use edit replace

replace what =

replace with ZZZ=

delete the column

reverse the edit replace

 

[Todd]

Thanks, it worked!

-----Original Message-----
use edit replace

replace what =

replace with ZZZ=

delete the column

reverse the edit replace

--
Regards,
Tom Ogilvy




.