"CAPTGNVR" wrote...
Pls help me. I am reposting this as got no response. I was counting
on Dave, Tom, Chip and Bob to help me out. It is excel 1997. I have
one range in a sheet referring to cells from another sheet. I used to
copy and paste to access the values from the other sheet. Suddenly
now if I copy and paste I am getting #REF! error. Pls enlighten me as
to what could be the reason. I will be eagerly waiting as I am not
able to do lots of calculations bcos of this problem.

Do you mean you're getting #REF! errors in the pasted range? Or in some
other range referring to the pasted range? Or to yet another range referring
to the original range that you copied?

If the first, what are the formulas in the original range copied and the
destination range pasted? Note: if cell G3 contained the formula =C3, and
you copy G3 and paste into D7, the formula becomes =#REF! because there's no
4th column to the left of column D.