| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Accessing named ranges in Excel from VBA
Can anyone tell me if and how I can access a named range on a worksheet in a VBA procedure? The value of the cell is read from a record with vlookup, I need to be able to access it in a procedure in VBA as input in a new record. Thankx, Basz -- Basz ------------------------------------------------------------------------ Basz's Profile: http://www.excelforum.com/member.php...o&userid=12340 View this thread: http://www.excelforum.com/showthread...hreadid=394589 |
|
#2
|
|||
|
|||
|
Worksheets("Sheet1").Range("myName")
You can get the Value property if it is a single cell, or use the Cells property if there are many. -- HTH Bob Phillips "Basz" wrote in message ... Can anyone tell me if and how I can access a named range on a worksheet in a VBA procedure? The value of the cell is read from a record with vlookup, I need to be able to access it in a procedure in VBA as input in a new record. Thankx, Basz -- Basz ------------------------------------------------------------------------ Basz's Profile: http://www.excelforum.com/member.php...o&userid=12340 View this thread: http://www.excelforum.com/showthread...hreadid=394589 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Importing Excel database into Outlook Contacts says "No Named Rang | Excel Discussion (Misc queries) | |||
| Calculating with named ranges | Excel Discussion (Misc queries) | |||
| Named ranges - column/row question | Excel Discussion (Misc queries) | |||
| Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel | |||
| vlookup and named ranges | Excel Worksheet Functions | |||
Linear Mode
