Rather than copy the formula you could use a UDF to show the formula.

Function ShowFormula(Cell)
Application.Volatile
ShowFormula = "No Formula"
If Cell.HasFormula Then ShowFormula = Mid(Cell.Formula, 2)
End Function

Usage is: =ShowFormula(cellref) will return SUM(B8:B15)


Gord Dibben MS Excel MVP

On Thu, 29 Nov 2007 13:11:00 -0800, Silena K-K
wrote:

Is it possible to copy a formula from a cell and paste it as text?

I am writing spreadsheet validation documents which must show the formula
used in each calculated cell eg: =SUM(B8:B15) is written as SUM(B8:B15).

Thanks