Hi,
The way to do it is
Worksheets("abc").Cells(1,2).FormulaR1C1="=Sum(myr ange)"

By the way when you are asking a new question it is advisable to start a new
thread. Otherwise people may not pay attention to your new query. :-)

Alok


"dreamz" wrote:


nevermind, i have a question.

how do i make it so that the formula is pasted into a cell rather than
a value?


--
dreamz
------------------------------------------------------------------------
dreamz's Profile: http://www.excelforum.com/member.php...o&userid=26462
View this thread: http://www.excelforum.com/showthread...hreadid=479943