Row Insertion Problem

[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.

 

[Max]

One thought ..
Safest and easiest to protect the sheet, with a password
Prevent any damage caused by users inserting/deleting rows/cols
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik

 

[Jon]

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