#ref! error. End-user moving precedent cell. Prevention?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created a sheet which is used by the end users to list the production in
their department. I have cells with in the sheet that refer to other cells.
All calculations work great until the end user cuts a precedent cell to a new
location. Once the cell has been moved to a new location the #ref! error
appears. I tried protecting the sheet and using the "$" to lock the cell
reference location but neither technique worked. Please help.

I am using Excel 2002.
 
The $ only locks the cell reference in the formula. If you move the cell the
cell reference in the formula will not change. For example =C8*$B$4 if the
contents of cell B4 and moved to A5 then the formula will not change. The
only way I can see in order to get around the #REF problem is to move the
cell using the black border as this should update the cell reference if it is
moved, rather than cutting the cell

Regards

Peter
 

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 Columns moving up and down on their own in a worksheet. What Goes? 2
#REF! 2
Excel Move or Copy Stopped Working? 0
Selecting Precedents On Other Sheet Via Macro 3
Run two macros for two different sheets 11
Excel How to run multiple Private Sub Worksheet_Change(ByVal Target As Range) 0
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
Excel Cannot delete empty cells/rows 4

Back
Top