Depends on rather the range name is workbook level or worksheet level

Workbook level syntax:

Workbooks("Book1.xls").Worksheets("Sheet1").Range( "RangeName")

Worksheet level syntax:

Workbooks("Book1.xls").Worksheets("Sheet1").Range( "Sheet1!RangeName")

Or when the worksheet's name has at least 1 space in it and it's a worksheet
level range name.

Workbooks("Book1.xls").Worksheets("Sheet 1").Range("'Sheet 1'!RangeName")


--
Ronald R. Dodge, Jr.
Production Statistician/Programmer
Master MOUS 2000

"Sandy" wrote in message
...
How can I address via vb the value stored in a named range cell.

example: on worksheet 3 I have a cell named variable 1

I want to retrive the value from that cell without going to it and
selecting
it. Is there a way?

Thanks