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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Help to copy information from one row at a time to another sheet 1
VBA - retrieve data on last create named range from previous inserted named range 0
Insert row including formula 3
Sum variable range of column entries in offset cell 2
Excel Allowing users to add rows in protected excel table 2
copy / paste as values 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Excel-Adding rows to master sheet that will be inserted on following worksheets 1

Back
Top