Long Formula in cell and REF!

[rodich]

Dear all,
I have some sheets with raw (source) data. First I copy them from the external XLS or MHTML file. I have button with macro for these actions.
I the next sheets I calculate Initial/Final Balance with static formulas in cells with fields from source or from custom fields.

I lost some of the columns when I replace data with in source sheets ....

Please Login or Register  to view this content.

I dont understand why ?!?!
How can I avoid it?
Thank you in advance for help!!

[oeldere]

Probably, you deleted a column.

There was a cellreference to cells in that column.

[rodich]

I made debug and .... found it! Thank you!!!!!!!!!
I make this button before one year and I forgot for deletion .... Thank you for help!!