I am creating a formula for an Excel cell in the macro. The address that I want to put in the formula is the evaluation of an expression in the macro (cell(x,y).address). How do I get VBA to put the value of the expression into the formula.

Right now, the resulting Excel cell looks like this: =sum(1,-cell(x,y).address) . I want: =sum(1,-a3)