Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Active Cell Value in a Calculation
This is crude but it works for me...
Sub cellcalc() Dim deeone deeone = Range("d1").Value ActiveCell.Value = Round((deeone * ActiveCell.Value), 2) End Sub "tedd13" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Row select mode to highlight active row of active cell | Excel Discussion (Misc queries) | |||
referring to formula in a non active cell from active cell | Excel Discussion (Misc queries) | |||
Macro to paste in the active cell the contents of a cell from another file?? | Excel Programming | |||
I need to sort an active sheet using the col of the active cell | Excel Programming | |||
Copy from active sheet and paste into new sheet using info from cell in active | Excel Programming |