On Feb 12, 11:46 pm, "Jon Peltier"
wrote:
If your formulas refer to a cell in column A, and you delete column A, the
reference to the cell is changed to #REF!

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutionshttp://PeltierTech.com
_______

"CAPTGNVR" wrote in message

oups.com...

DEAR ALL
I HAVE A FILE BY NAME SAY CARGO.XLS. In this file there are 20
sheets. In VB i transfer the say three sheets from the cargo.xls file
for transmitting from the cargo control to the radio room.
What i cant figure out is if I open one sheet and then the other some
of the cells get # ref error.
For your information-- I do not have any links in the cells showing
this error. The formulas in these sheets are referring to the sheet
cells itself. What could be the cause. Pls advice.

D/PETER, thnks ur response. In radio room i open the first sheet
exported and it is fine. I open the second sheet and it is also
fine. When i go back to the first sheet then it shows these ref
errors in cells. All these days i did not face this and unable to
ustand the reason for this.