No. I am copying from one cell in a column to the next cell in the column.
I only get the value from the previous cell (not the new value computed from
the new column with the copied formula. Also no formatting is copied.
Thanks for your speedy response.



"Jim Thomlinson" wrote:

Are you copying and pasting between workbooks perhaps. If so then check to
see if the workbooks are in seperate instances of XL. That would cause the
behavior you are describing...
--
HTH...

Jim Thomlinson


"Bill B" wrote:

Something happened. Now I can't copy and paste a formula from one cell to
another in my worksheet??? It only want's to paste text.
Even with paste special, I have lost the old dialog box and have a new one
that only allows pasting text.