Hi

is this what you're after

Sub pasteformula()
Range("D1").Formula = "=SUM(myname)"
End Sub

Cheers
JulieD

"R. Choate" wrote in message
...
I want to paste a formula which has a defined name and does not exist in
any cell on any worksheet before I paste it. I know that
defined name formulas can be referred to by other formulas on a worksheet,
but I want to paste the defined name formulas
programmatically. I know that there are other ways to accomplish what I'm
doing in my project without using the named formulas, but
using them would be a lot cleaner for me and I want to take advantage of
that feature if possible. Any ideas?

--
RMC,CPA