Refererence to a value in a cell
try sheet1.range("a3")
or sheet1.range("a3").value
Libby
-----Original Message-----
Hi
Does anyone knwo how I can refer to a cell value (e.g
a3).
At present using the Target.Address, I can only refer to
the active cell.
Also if the cell has a forumla, how to refer to the
result
or the value of the formula in the cell.
Regards
ZAK
.
|