Read cell value with a macro

  • Thread starter Thread starter jbuthmann
  • Start date Start date
J

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?
 
Back
Top