Hi Bathan,

wrote:
What does this give you when run from the Immediate Window:

?Range("rows").value

I get :
Run-time error '1004'
Application-defined or object-defined error.
<snip
If I enter "=rows" into any cell of the
worksheet I do get "3", which is what I have defined "rows" to refer
to.

OK. It may be that you defined the name to be a worksheet-level name. In
that case, try this:

?Worksheets("Sheet1").Range("rows").Value

[replace Sheet1 with the name of the worksheet your named range resides on]

If this gives you 3, then you have a worksheet-level name and not a global
(workbook-level) name. No problem, but you'll need to specify the worksheet
whenever you refer to it in your code.

--
Regards,

Jake Marx
www.longhead.com


[please keep replies in the newsgroup - email address unmonitored]