Refererence to a value in a cell

Z

ZAK

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
 
L

Lars Kofod

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Worksheet_SelectionChange & Worksheet_Change results in different Targets 2
VB Script reference cells for in current table? 1
Return BLANK is cell value sought is blank 13
Copy addition formula of non-consecutive horizontal cells 2
VBA Assigning cell value to variable giving runtime error 3
Drop down list control value in vba 2
VBA Coding Help for Beginner 0
macro to run in event of cell value <>"" 2

Top