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?

Signature
jbuthmann
Norman Jones - 25 Jan 2006 02:26 GMT
Hi J,
Try:
ActiveCell.value
---
Regards,
Norman
> 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
[quoted text clipped - 5 lines]
> 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?