SallyGirl Wrote:
I am trying to copy a series of cells within the same colum and paste
within
that same colum without changing the formula....whenever I paste it
changes
the formula to match the cells that I am pasting it in.
For example:
A4=sum(A1:A4)
I want to past this formula into A5 where it still reads (A1:A4)

I know that I am making this harder than it needs to be!
Please helpi Sally,

First this formula in cell A4 will give you a circular reference. But
to answer your question.

Make cell A4 active, then highlight and copy the formula from the
"Formula Bar", hit "Enter"
then go to the destination cell and paste normal. (Formula
Barcopyenterpaste)


--
Desert Piranha


------------------------------------------------------------------------
Desert Piranha's Profile: http://www.excelforum.com/member.php...o&userid=28934
View this thread: http://www.excelforum.com/showthread...hreadid=574041