Read cell value with a macro

[jbuthmann]

I tried to record a macro to read the cell value of the active cell.
The macro recorded the actual value of the cell I had selected at the
time. So if I select a different cell and run the macro it still reads
the same constant value as when I recorded it the first time. Example:
ActiveCell.FormulaR1C1 = "212"

I want it to read the value of the cell I have selected as a variable
and not a constant. I have looked through the help files but I must
not be asking the right questions. Can anybody set me straight?

 

[Norman Jones]

Hi J,

Try:

ActiveCell.value