That was it!!!! Thanks

"Ikaabod" wrote:


It looks to me that you're missing what digit it is to round to.
Try this:
ActiveCell.FormulaR1C1 = "=ROUND(RC[-1]*R3C2,0)"

where 0 is the digit to be rounded to.

-Ikaabod

tedd13 Wrote:
Thanks...but I still can't get it to work.

Here is my formula: ActiveCell.FormulaR1C1 = "=ROUND(RC[-1]*R3C2)"

So I should get the value in cell B3, right? I have a value there.
When I
run it I get an Application or Object Defined Error.

What do you think I am doing wrong?

Thanks again.



[/color]


--
Ikaabod
------------------------------------------------------------------------
Ikaabod's Profile: http://www.excelforum.com/member.php...o&userid=33371
View this thread: http://www.excelforum.com/showthread...hreadid=540656

[/color]