Adding entries to a data validation list - how to do without renaming?

I don't know exactly what the problem is but there should not be one. Do
this. Say your list is in A1:A10. Select A1:A10. Find the Name box. It
is immediately above the "A" of Column A and displays the cell address of
the active cell. Click in the Name box. Type in "Region" (your range name)
without the quotes. Hit enter. That range is now named Region.
Now if you have to change the range, just do so. Then select the new
range and repeat what you did before. Use the same name. HTH Otto
"StargateFan" <IDon'tAcceptSpam@IDon'tAcceptSpam.com> wrote in message
news:lmh101p7dcevb79n53j10bm8nuosa40l3j@4ax.com...
>I 've run into this a few times now, so thought there must be a better
> way.
>
> In XL2K, when I create a data validation list and then name the region
> (I think it's called region), then when I go back to continue working
> on the spreadsheet, I often realize I've missed a value or two and try
> to add.
>
> This never works with the same name, so I have to rename the list and
> go back to the data validation information and put the new name of the
> values and edit the cells one by one. I know there must be a better
> way, but I haven't figured one out.
>
> Thanks.
>

Hi Otto

AFAIK you can't use the same name again using this method (well it never
works for me anyway!).

Cheers
JulieD

"Otto Moehrbach" <ottokmnop@comcast.net> wrote in message
news:Oc%233wfSCFHA.3840@tk2msftngp13.phx.gbl...
>I don't know exactly what the problem is but there should not be one. Do
>this. Say your list is in A1:A10. Select A1:A10. Find the Name box. It
>is immediately above the "A" of Column A and displays the cell address of
>the active cell. Click in the Name box. Type in "Region" (your range
>name) without the quotes. Hit enter. That range is now named Region.
> Now if you have to change the range, just do so. Then select the new
> range and repeat what you did before. Use the same name. HTH Otto
> "StargateFan" <IDon'tAcceptSpam@IDon'tAcceptSpam.com> wrote in message
> news:lmh101p7dcevb79n53j10bm8nuosa40l3j@4ax.com...
>>I 've run into this a few times now, so thought there must be a better
>> way.
>>
>> In XL2K, when I create a data validation list and then name the region
>> (I think it's called region), then when I go back to continue working
>> on the spreadsheet, I often realize I've missed a value or two and try
>> to add.
>>
>> This never works with the same name, so I have to rename the list and
>> go back to the data validation information and put the new name of the
>> values and edit the cells one by one. I know there must be a better
>> way, but I haven't figured one out.
>>
>> Thanks.
>>
>
>

Nor me, when you re-enter the name, it just selects the previous range.

Bob


"JulieD" <JulieD@hctsReMoVeThIs.net.au> wrote in message
news:%23CKkauTCFHA.2568@TK2MSFTNGP10.phx.gbl...
> Hi Otto
>
> AFAIK you can't use the same name again using this method (well it never
> works for me anyway!).
>
> Cheers
> JulieD
>
> "Otto Moehrbach" <ottokmnop@comcast.net> wrote in message
> news:Oc%233wfSCFHA.3840@tk2msftngp13.phx.gbl...
> >I don't know exactly what the problem is but there should not be one. Do
> >this. Say your list is in A1:A10. Select A1:A10. Find the Name box.
It
> >is immediately above the "A" of Column A and displays the cell address of
> >the active cell. Click in the Name box. Type in "Region" (your range
> >name) without the quotes. Hit enter. That range is now named Region.
> > Now if you have to change the range, just do so. Then select the new
> > range and repeat what you did before. Use the same name. HTH Otto
> > "StargateFan" <IDon'tAcceptSpam@IDon'tAcceptSpam.com> wrote in message
> > news:lmh101p7dcevb79n53j10bm8nuosa40l3j@4ax.com...
> >>I 've run into this a few times now, so thought there must be a better
> >> way.
> >>
> >> In XL2K, when I create a data validation list and then name the region
> >> (I think it's called region), then when I go back to continue working
> >> on the spreadsheet, I often realize I've missed a value or two and try
> >> to add.
> >>
> >> This never works with the same name, so I have to rename the list and
> >> go back to the data validation information and put the new name of the
> >> values and edit the cells one by one. I know there must be a better
> >> way, but I haven't figured one out.
> >>
> >> Thanks.
> >>
> >
> >
>
>

JulieD & Bob
Is there no end to this learning business? Thanks for that correction.
I do know, though, that the Insert - Name - Define works. Just type the
same name with the new reference. Otto
"Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
news:uLtHK7TCFHA.3592@TK2MSFTNGP09.phx.gbl...
> Nor me, when you re-enter the name, it just selects the previous range.
>
> Bob
>
>
> "JulieD" <JulieD@hctsReMoVeThIs.net.au> wrote in message
> news:%23CKkauTCFHA.2568@TK2MSFTNGP10.phx.gbl...
>> Hi Otto
>>
>> AFAIK you can't use the same name again using this method (well it never
>> works for me anyway!).
>>
>> Cheers
>> JulieD
>>
>> "Otto Moehrbach" <ottokmnop@comcast.net> wrote in message
>> news:Oc%233wfSCFHA.3840@tk2msftngp13.phx.gbl...
>> >I don't know exactly what the problem is but there should not be one.
>> >Do
>> >this. Say your list is in A1:A10. Select A1:A10. Find the Name box.
> It
>> >is immediately above the "A" of Column A and displays the cell address
>> >of
>> >the active cell. Click in the Name box. Type in "Region" (your range
>> >name) without the quotes. Hit enter. That range is now named Region.
>> > Now if you have to change the range, just do so. Then select the
>> > new
>> > range and repeat what you did before. Use the same name. HTH Otto
>> > "StargateFan" <IDon'tAcceptSpam@IDon'tAcceptSpam.com> wrote in message
>> > news:lmh101p7dcevb79n53j10bm8nuosa40l3j@4ax.com...
>> >>I 've run into this a few times now, so thought there must be a better
>> >> way.
>> >>
>> >> In XL2K, when I create a data validation list and then name the region
>> >> (I think it's called region), then when I go back to continue working
>> >> on the spreadsheet, I often realize I've missed a value or two and try
>> >> to add.
>> >>
>> >> This never works with the same name, so I have to rename the list and
>> >> go back to the data validation information and put the new name of the
>> >> values and edit the cells one by one. I know there must be a better
>> >> way, but I haven't figured one out.
>> >>
>> >> Thanks.
>> >>
>> >
>> >
>>
>>
>
>

On Wed, 2 Feb 2005 13:33:10 -0500, "Otto Moehrbach"
<ottokmnop@comcast.net> wrote:

>JulieD & Bob
> Is there no end to this learning business? Thanks for that correction.
>I do know, though, that the Insert - Name - Define works. Just type the
>same name with the new reference. Otto

Sounds great! Knew there'd have to be a way. I'll go try it now.

Phew, thank goodness as it was getting to be a bit of a problem. One
doesn't always have all the data handy when one is creating the range
<g>.

Cheers!

>"Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
>news:uLtHK7TCFHA.3592@TK2MSFTNGP09.phx.gbl...
>> Nor me, when you re-enter the name, it just selects the previous range.
>>
>> Bob
>>
>>
>> "JulieD" <JulieD@hctsReMoVeThIs.net.au> wrote in message
>> news:%23CKkauTCFHA.2568@TK2MSFTNGP10.phx.gbl...
>>> Hi Otto
>>>
>>> AFAIK you can't use the same name again using this method (well it never
>>> works for me anyway!).
>>>
>>> Cheers
>>> JulieD
>>>
>>> "Otto Moehrbach" <ottokmnop@comcast.net> wrote in message
>>> news:Oc%233wfSCFHA.3840@tk2msftngp13.phx.gbl...
>>> >I don't know exactly what the problem is but there should not be one.
>>> >Do
>>> >this. Say your list is in A1:A10. Select A1:A10. Find the Name box.
>> It
>>> >is immediately above the "A" of Column A and displays the cell address
>>> >of
>>> >the active cell. Click in the Name box. Type in "Region" (your range
>>> >name) without the quotes. Hit enter. That range is now named Region.
>>> > Now if you have to change the range, just do so. Then select the
>>> > new
>>> > range and repeat what you did before. Use the same name. HTH Otto
>>> > "StargateFan" <IDon'tAcceptSpam@IDon'tAcceptSpam.com> wrote in message
>>> > news:lmh101p7dcevb79n53j10bm8nuosa40l3j@4ax.com...
>>> >>I 've run into this a few times now, so thought there must be a better
>>> >> way.
>>> >>
>>> >> In XL2K, when I create a data validation list and then name the region
>>> >> (I think it's called region), then when I go back to continue working
>>> >> on the spreadsheet, I often realize I've missed a value or two and try
>>> >> to add.
>>> >>
>>> >> This never works with the same name, so I have to rename the list and
>>> >> go back to the data validation information and put the new name of the
>>> >> values and edit the cells one by one. I know there must be a better
>>> >> way, but I haven't figured one out.
>>> >>
>>> >> Thanks.
>>> >>
>>> >
>>> >
>>>
>>>
>>
>>
>

On Wed, 2 Feb 2005 23:25:52 +0800, "JulieD"
<JulieD@hctsReMoVeThIs.net.au> wrote:

>Hi Otto
>
>AFAIK you can't use the same name again using this method (well it never
>works for me anyway!).

Ditto. The same name has never worked for me.
>
>Cheers
>JulieD
>
>"Otto Moehrbach" <ottokmnop@comcast.net> wrote in message
>news:Oc%233wfSCFHA.3840@tk2msftngp13.phx.gbl...
>>I don't know exactly what the problem is but there should not be one. Do
>>this. Say your list is in A1:A10. Select A1:A10. Find the Name box. It
>>is immediately above the "A" of Column A and displays the cell address of
>>the active cell. Click in the Name box. Type in "Region" (your range
>>name) without the quotes. Hit enter. That range is now named Region.
>> Now if you have to change the range, just do so. Then select the new
>> range and repeat what you did before. Use the same name. HTH Otto
>> "StargateFan" <IDon'tAcceptSpam@IDon'tAcceptSpam.com> wrote in message
>> news:lmh101p7dcevb79n53j10bm8nuosa40l3j@4ax.com...
>>>I 've run into this a few times now, so thought there must be a better
>>> way.
>>>
>>> In XL2K, when I create a data validation list and then name the region
>>> (I think it's called region), then when I go back to continue working
>>> on the spreadsheet, I often realize I've missed a value or two and try
>>> to add.
>>>
>>> This never works with the same name, so I have to rename the list and
>>> go back to the data validation information and put the new name of the
>>> values and edit the cells one by one. I know there must be a better
>>> way, but I haven't figured one out.
>>>
>>> Thanks.
>>>
>>
>>
>

On Wed, 2 Feb 2005 08:05:55 -0500, "Otto Moehrbach"
<ottokmnop@comcast.net> wrote:

>I don't know exactly what the problem is but there should not be one. Do
>this. Say your list is in A1:A10. Select A1:A10. Find the Name box. It
>is immediately above the "A" of Column A and displays the cell address of
>the active cell. Click in the Name box. Type in "Region" (your range name)
>without the quotes. Hit enter. That range is now named Region.
> Now if you have to change the range, just do so. Then select the new
>range and repeat what you did before. Use the same name. HTH Otto

But that's just it, you select the range and go to name it but if you
use the same name, the region selected shrink back to what it was
originally. And then when I'd go back to the spreadsheet, the new
data wasn't added.

I'll try Bob Phillips' workaround as it seems that a solution other
than trying to add the info physically would work. I've run into this
before in other contracts, and therefore other machines, so this isn't
the first time this has happened to me.

Thanks.

>"StargateFan" <IDon'tAcceptSpam@IDon'tAcceptSpam.com> wrote in message
>news:lmh101p7dcevb79n53j10bm8nuosa40l3j@4ax.com...
>>I 've run into this a few times now, so thought there must be a better
>> way.
>>
>> In XL2K, when I create a data validation list and then name the region
>> (I think it's called region), then when I go back to continue working
>> on the spreadsheet, I often realize I've missed a value or two and try
>> to add.
>>
>> This never works with the same name, so I have to rename the list and
>> go back to the data validation information and put the new name of the
>> values and edit the cells one by one. I know there must be a better
>> way, but I haven't figured one out.
>>
>> Thanks.
>>
>