Did you try

formulalocal
or
formular1c1
?

maybe one of those work.
Are you sure, that D12 = D11 + D7?

hth

Carlo

On Dec 18, 2:00 pm, Gleam wrote:
I have this line of code:
MyStr = Cells(12 , "D").Formula

I expect it to return "=D11 + D7" but it reurns the the value Cells(12 ,
"D").Value

How do I get the formula?