Accessing named ranges in Excel from VBA

B

Basz

Can anyone tell me if and how I can access a named range on a workshee
in a VBA procedure?

The value of the cell is read from a record with vlookup, I need to b
able to access it in a procedure in VBA as input in a new record.

Thankx,
Bas
 
B

Bob Phillips

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.
 
Top