On sheet1 select A1:A3

InsertNameDefineMyName

=!$A$1:$A$3

Note: won't show up in the NameBox but can be entered in F5 dialog box.


Gord Dibben MS Excel MVP

On Thu, 22 Nov 2007 00:50:01 -0800, oldLearner57
wrote:

thanks "JMB" for the guidance...
perhaps my request was not properly stated...
what I am looking for is..

assumed I had data already entered into range of cells say at

worksheet 1 - range a1:a3 (with data)

worksheet 2 - range a1:a3 (with data - similar with worksheet 1)

how do i declare a name range for both of them without having to manually
selecting worksheet 1 and perform the Name Range steps

thereafter

go into worksheet 2 and repeat the similar steps as for worksheet 1

it is ok for just say 2 or 3 worksheets but if say, I have 25 worksheets and
wanted to have their similar name range (with similar data) all to have a
"Name" and whenever I am in whichever worksheet, all I need to do is go to
the Name Box and click the Name.

hope now this is clearer

or that is no possible way to have it done in this way ???

many thanks for the guidance :)

thanks to community as well :)