View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Erinayn Erinayn is offline
external usenet poster
 
Posts: 23
Default Changing the range for my drop down menu

I have a daily checklist that I created that has drop down menus with
people's names so I can select who sent the document that day. Recently there
has been a new person that sends and I'd like to add them to the drop down
choices.

I've added the new name under the 1 name (the group only had one) and
highlight the 2 cells and rename the range in the name box it doesn't take.
It still has the original 1 name as the range.

What am I doing wrong?