Sorry, You said r1c1

--
Don Guillett
SalesAid Software

"Don Guillett" wrote in message
...
Sub makeformula()
[n5].Formula = "=SUM($G10:$G20)"
'[n5].Formula =[n5].value'to chg to value
End Sub


--
Don Guillett
SalesAid Software

"Michael D. Ober" <[email protected] wrote in message
...
I need to have VBA create formulas with mixed referencing such as:

=SUM($G10:$G20)

I can create =SUM($G$10:$G$20) and =SUM(G10:G20), neither of which is
what
I
need.

Thanks,
Mike.