Insert Excel Formula into Macro

[chrysti]

If I wanted to just insert a formula into my macro in Excel to paste into a cell how would I do that???

I thought it had something to do with a "HOT" statement, but I am not sure.

I just want to paste a formula into a cell with my macro.

Thanks in advance for the help...
Chrysti

 

[ravishankar]

Hi
The answer varies based on where you want to paste and what formula you want to insert and........
cells(1,1) = "=sum(A2:A20)"
will paste the formula in Cell A1 and the formula sums cells A2 to A20
Ravi