View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tedd13 tedd13 is offline
external usenet poster
 
Posts: 22
Default Using Active Cell Value in a Calculation

Hello,
I am trying to use the value in a cell in a calculation. But I want the
results of the calculation to stay in the cell.

Here is my formula: =ROUND(D1*ActiveCell.Value,2). The active cell contains
the value 0.1017.

Is there a way to use the value in a cell and replace it with the results of
a calculation?

Thanks