Thread: Using Relative Reference in a Formula
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Ikaabod[_37_] Ikaabod[_37_] is offline
external usenet poster
  
Posts: 1
Default Using Relative Reference in a Formula

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][/color]


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

Reply With QuoteReply With Quote