Delete rows in Excel file with macros

[Krassimir]

Hello! I have big Excel file with many formulas. It
contains a lot of data. When I delete part of the data,
some of the values in the remain cells change. I receive
these word: #REF. After that I delete #REF in one cell and
I fill the necessary value. I press "Enter" key and the
values in the same column become right. But the values in
the remain cells are still #REF. Please help me to delete
part of the data in my file without changing of remain
data!