Refererence to a value in a cell
 

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

Refererence to a value in a cell
 

Set the value of a3 to x
Range("a3").value=x

Read the value of a3 and assign it to x
x=Range("a3").value

The above also gives the result of a formula in a cell.


Lars Kofod
-----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
.

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
.