DEAR ALL
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.

"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.

On Jul 16, 3:34 pm, "Harlan Grove" wrote:
"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.

D/HARLAN
Thanks ur response. I have the below formulas for example in one
sheet in col-AA
=IF(PAWY_INPUT!G4="","",PAWY_INPUT!G4)
=IF(PAWY_INPUT!G5="","",PAWY_INPUT!G5)

I used to copy and paste it in say col -B of the same sheet and it
was working fine. I was doing lots of changes and dont know what
happened -- now when i copy and paste it in col-B i get this #REF!.
In a new workboom it works fine. But i hv gone too deep in this
workbook to ignore this. pls adv

On Jul 16, 3:45 pm, CAPTGNVR wrote:
On Jul 16, 3:34 pm, "Harlan Grove" wrote:



"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.

D/HARLAN
Thanks ur response. I have the below formulas for example in one
sheet in col-AA
=IF(PAWY_INPUT!G4="","",PAWY_INPUT!G4)
=IF(PAWY_INPUT!G5="","",PAWY_INPUT!G5)

I used to copy and paste it in say col -B of the same sheet and it
was working fine. I was doing lots of changes and dont know what
happened -- now when i copy and paste it in col-B i get this #REF!.
In a new workboom it works fine. But i hv gone too deep in this
workbook to ignore this. pls adv

D/HARLAN
wow. Real valid info u gave me. U guided me well. I changed the cell
to absolute ref like =IF(PAWY_INPUT!$G$6="","",PAWY_INPUT!$G$6)
and then when i copy and paste it works. Now at least again I am
proceeding with the further calculations.