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

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