hello: Is there a way to expand a named range being used as a dropdown when new names are added to the range. for eg is there is data from A1 to A5 and the range is named "NAME". Is there a way to automatically expand the range when a name is added in A6 so that is also appears in the dropdown?
Thanks
rlsublime,
What you're looking for is Dynamic Named Ranges. Here's some links to get you started:
http://support.microsoft.com/kb/830287
http://www.contextures.com/xlnames01.html
http://www.cpearson.com/excel/DefinedNames.aspx
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Have you read the tips yet?
Cheers,
Would you like to say thanks? Please click the: "Add Reputation" button, on the grey bar below the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks