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.

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
---
"robot" wrote in message
...
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

"robot" wrote:

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.