VBA calculation using named ranges

[scoha]

I have two dynamic named ranges wich are columns inmy worksheet.

I want to use VBA to calculate the difference between the values in each range:

Sheets("ClosedIssues").Cells(i, "M").Formula = "DynResolved-DynResolution"

and place the answer in Col M.

My code doesnt work - but could someone give me a pointer as to where its wrong?

 

[mikerickson]

.Formula = "=DynResolved-DynResolution"

If they are multi-cell ranges, perhaps

Sheets("ClosedIssues").Cells(1, "M").Resize(Range("DynResolved").Rows.Count,1).FormulaArray = "=DynResolved-DynResolution"

 

[scoha]

Nailed it - thanks MikErickson