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:

Please Login or Register  to view this content.

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.

Please Login or Register  to view this content.

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!