Do'h. I did not even notice that was on there. Thanks.

Rick Rothstein wrote:
Don't use FormulaR1C1 for a formula using normal ranges, use just Formula...

ActiveCell.Formula = "=Sum(" & StartCell & ":" & EndCell & ")"

I am trying to use the below code to insert
"=SUM(D2:D3)"
[quoted text clipped - 15 lines]
of
the ' so that the formula will actually work?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200809/1