| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
access a cell by it's name
Hello
I need to access a certain cell in a worksheet, but I don't know the coordinates (row,col = because it may be moved when inserting rows or cols). So I tried to name that cell, but now I don't know how to access that named cell from the macro code. Can anybody help me? Thanks! Simon Sunke |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
access a cell by it's name
If you named the cell "QQQ", then in VBA:
Sub a() Range("QQQ") = 123 MsgBox Range("QQQ") End Sub -- Regards Andy Wiggins www.BygSoftware.com Home of "Save and BackUp", "The Excel Auditor" and "Byg Tools for VBA" "Simon Sunke" wrote in message ... Hello I need to access a certain cell in a worksheet, but I don't know the coordinates (row,col = because it may be moved when inserting rows or cols). So I tried to name that cell, but now I don't know how to access that named cell from the macro code. Can anybody help me? Thanks! Simon Sunke |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
access a cell by it's name
myvar = Range("my_name").Value
-- Rob van Gelder - http://www.vangelder.co.nz/excel "Simon Sunke" wrote in message ... Hello I need to access a certain cell in a worksheet, but I don't know the coordinates (row,col = because it may be moved when inserting rows or cols). So I tried to name that cell, but now I don't know how to access that named cell from the macro code. Can anybody help me? Thanks! Simon Sunke |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
access a cell by it's name
Hi Simon,
Try something like MsgBox Range("myrange").Value -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Simon Sunke" wrote in message ... Hello I need to access a certain cell in a worksheet, but I don't know the coordinates (row,col = because it may be moved when inserting rows or cols). So I tried to name that cell, but now I don't know how to access that named cell from the macro code. Can anybody help me? Thanks! Simon Sunke |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
access a cell by it's name
Hey thanks a lot to all of you...
works great with the Range Object. Is there any good tutorial on the web where I could have found that answer (to stop bugging you with such questions in the future...) Simon |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
access a cell by it's name
Try Google Groups.
It's pretty good to search back through old articles. Pair this with Excel's Help and you've got a winning combination. -- Rob van Gelder - http://www.vangelder.co.nz/excel "Simon Sunke" wrote in message ... Hey thanks a lot to all of you... works great with the Range Object. Is there any good tutorial on the web where I could have found that answer (to stop bugging you with such questions in the future...) Simon |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Single cell access | Excel Discussion (Misc queries) | |||
| how to access a cell value in a different workbook. HELP! | Excel Worksheet Functions | |||
| can i access the cell colour programatically? eg if cell is blue | Excel Discussion (Misc queries) | |||
| how do i set up a link between one excel cell from an access cell | Excel Discussion (Misc queries) | |||
| Cell access | Excel Programming | |||
Hybrid Mode
