View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
BrianW
 
Posts: n/a
Default Why doen't PasteSpecial, Formulas not display formula in cell?

I want to paste the formul's from a cell into another cell. Other
spreadsheet programs allow this for a single cell. I'm aware of paste
special , select formula button but the value is displayed. I can make this
work by copying the text in a fourmul and preceeding the past in another cell
with a ', but this is very cumbersom when I have to do it hundreds of times
in a column, and the result is not associative with the source.