Reference to cell - VBA

[Darryl Kirtland]

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

 

[schoujar]

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!