Tough one - Cell referencing in Excel/VBA
My result in Sheet2 was...
=AVERAGE(Sheet1!A3:A4)
--
Jim Cone
Portland, Oregon USA
"warrenshooter"
wrote in message
...
Neat trick. I haven't seen that before.
Unfortunately the result in Sheet2!A5 was still "=Average(A3,A4)". I was
after ="Average(Sheet1!A3,Sheet1!A4)"
Cheers
"Jim Cone" wrote:
Another way...
Select both sheets before entering the formula.
--
Jim Cone
Portland, Oregon USA
"warrenshooter"
wrote in message
...
I have two sheets (Sheet1 and Sheet2)
In cell A5 in Sheet1 I have a formula "=Average(A3,A4)"
I would like to copy this formula to cell A5 in Sheet2 but have the formula
still reference Sheet1. In cell A5 in Sheet2 the formula should be
"=Average(Sheet1!A3,Sheet1!A4)"
If Sheet1!A5 was originally "=Average(Sheet1!A3,Sheet1!A4)" then there is no
problem.
Would love to hear the answer. It must be something simple.
Warren
|