And explicitly using Item is superfluous.

x = Range("myrange")(10,1).Value

works fine.

Alan Beban

Mike H wrote:
Karen,

Imagine your named range as a grid and you can refer it individual cells
within it like this:-

Sub sonic()
x = Range("myrange").Item(2, 2).Value
End Sub

item refers to row, column.
It's also useful to note that you can use this method to refer to cells
outside your named range so a 3,3 grid could iuse the reference 3,4 which
would rer to the column to the right of your grid.

So to return item 10,1 is
x = Range("myrange").Item(10, 1).Value

where "myrange" is the name of your range.

Mike