Re: HOW TO: Name Range?

Tech-Archive recommends: Fix windows errors by optimizing your registry

Unfortunately not, the Refers to for some reason changes, and it seems to
select the 10 cells below the active cell when I type in the Name dropdown,
not sure what I'm doing wrong.

TIA
KM

"Tom Ogilvy" wrote:

> All named ranges don't show up in the name dropdown, but will appear in
> Insert=>Names=>Define. This includes names that are variable in nature such
> as this one.
>
> In the name box, type in MyData and hit return. does it select the proper
> range?
>
> --
> Regards
> Tom Ogilvy
>
> "Kevin McCartney" <KevinMcCartney@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
> message news:5C60721E-514A-4CB7-A79F-2D155A44CFBE@xxxxxxxxxxxxxxxx
> > OK,
> >
> > I click on Insert | Name | Define, I type in the Names in workbook,
> MYDATA,
> > in the Refers to box I put =!A2:B10 click on Add then OK, but nothing
> shows
> > up in the Name Range List, what am I doing wrong, please help.
> >
> > TIA
> > KM
> >
> > "Bob Umlas" wrote:
> >
> > > Define the name and have it referring to the range A2:B10 WITH A LEADING
> > > EXCLAMATION MARK:
> > > MyData Refers to
> > > !A2:B10
> > > Now you have what I call a global/local name.
> > > See page 49 of my book "This isn't Excel it's Magic!"
> > > http://www.iil.com/iil/excelmagic
> > >
> > > "Kevin McCartney" <KevinMcCartney@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
> > > message news:BD41B7DA-F652-42D4-8E6D-A58EBF354990@xxxxxxxxxxxxxxxx
> > > > Hi TWIMC,
> > > >
> > > > I'd like to add one name range that works on each ***. E.g. I set a
> > > named
> > > > range called My Data and when I click on it, it selects the A2 to B10
> > > > depending on which *** is active, how do I do it?
> > > >
> > > >
> > > > TIA
> > > > KM
> > >
> > >
> > >
>
>
>
.

Quantcast