You can't select something if the sheet isn't active. Either activate
sheet1 first or use Application.Goto


You use local names when it is appropriate to your purpose.

You can have one global name and more than one local name with the same base
name. The local name takes precedence or masks the global name when
referenced on the sheet where it is local - similar to local variables and
global variables.

--
Regards,
Tom Ogilvy


"Tetsuya Oguma" wrote in message
...
Hi all,

I am a bit ocnfused with Names property. Please answer the following short
questions.
1. When to use local names and global names? I understand that If the same
name is used for both locally and globally local name only exists.
2. I have a named range "test" on Sheet1, with its 'referto' of
"=Sheet1!$A$1:$A$5", that I can see in Insert|Name|Define... from Menu Bar.
Then, in standard module (not behind sheet or class module) I have the
following code to select the range:
Range("test").Select

This give me an error of Run-tim error '1004': Select method of Range
failed. I really want to know why!!! How can I select the range (or
manipulate cells on the same sheet, to my point) if activesheet is not the
sheet that has that range?

I am using Excel 2000 SR-1.
---
Tetsuya, Sydney, Australia