thank you all so very much it worked for a while yet it is still doing
it
the formula has changed the original column say my original formula is
=sum($B3*C15) I would like the same formula along the rest of the row
being ($B3&d15),b3*e15, b3*f15 etc.... but its not working it will
change the formula


--
chrissywhittle
------------------------------------------------------------------------
chrissywhittle's Profile: http://www.excelforum.com/member.php...o&userid=32158
View this thread: http://www.excelforum.com/showthread...hreadid=520186