Subtract Ranges in VBA

[MarvJab]

I want to subtract two Ranges and put absolute answer in another Range. cell range is 35. Any ideas. I get the # sign as a answer in the correct cell range, but not the difference from the above two rows.

My code Below

Sub Subtract()

Dim Cell As Range

Range("D6:AL6") = "=abs(D4:AL4-D5:AL5)"

 

[Fluff]

Hi & welcome to MrExcel.
How about

Range("D6:AL6") = Evaluate("abs(D4:AL4-D5:AL5)")

 

[MarvJab]

Hi & welcome to MrExcel.
How about

Range("D6:AL6") = Evaluate("abs(D4:AL4-D5:AL5)")

Yes, It Worked. greatly appreciated. I was struggling with that as I'm teaching myself VBA. So glad I joined.

 

[Fluff]

You're welcome & thanks for the feedback.