Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nesting a sheet name reference within a cell reference??? | Excel Discussion (Misc queries) | |||
Changing sheet reference to cell reference | Excel Worksheet Functions | |||
absolute cell reference A spreadsheet cell reference that does no | Excel Discussion (Misc queries) | |||
problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions | |||
Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable | Excel Worksheet Functions |