Reference to cell - VBA
 

Hi

I'm trying to write a user defined function which references a cell in sheet
1 in my spreadsheet. Cell A10 currently has the value of 20 - how do I
reference this cell in my VBA program.

Thanks

Darryl

Reference to cell - VBA
 

Try this:


Code:
--------------------
Dim n as integer
n = Sheets(1).Cells(10,1).value
--------------------


where the 10 is row number as 1 is column number (hence A10).
A more efficient a safer way of referencing cells is to give them
names. So for example in your worksheet you defined cell A10's name to
be -number- then you can use the following code.


Code:
--------------------
Dim n as integer
n = Sheets(1).Range("number").value
--------------------


This way if you were to shift cell A10 to some other location on the
sheet you will not have to change the code.

Hope this helps!


--
schoujar
------------------------------------------------------------------------
schoujar's Profile: http://www.excelforum.com/member.php...o&userid=26574
View this thread: http://www.excelforum.com/showthread...hreadid=547311