Row Insertion Problem

  • Thread starter Thread starter robot
  • Start date Start date
R

robot

Hello,

I have a worksheet with a hidden column of formulas, each formula making
calculations using data on the respective row.

It is fine until a user inserts a row, as (unbeknownst to the user) the
respective cell of the row will be blank, causing calculation errors.

How best to tackle this issue?


Many thanks in advance.
 
Unless you are using absolute references, I'm having a hard time visualizing
when/how this would occur? Can you give a little more info?

-J
 
Back
Top