+ Reply to Thread
Results 1 to 6 of 6

Can the name of a range be dynamic?

  1. #1
    Forum Contributor Grimace's Avatar
    Join Date
    05-04-2009
    Location
    Gold Coast, Australia
    MS-Off Ver
    Excel 2013 and Office 365 Plus
    Posts
    378

    Can the name of a range be dynamic?

    Good morning

    I am working with named ranges in a datasheet, and would like to provide the end user with the option to name these ranges without going into the data sheet itself (trying to protect from inadvertent data corruption).

    Odd question ...... is the name of the range able to be dynamic? (eg can you use a cell refence instead of an actual name, and allow the user to enter a name into that cell that is then used by the name manager as the named range of a predefined or dynamic range of data)

    I am assuming no, but thought somebody here may have done this before

    Warm regards

    Darren.
    Handy things to keep in mind:

    Click *, if my suggestion has helped you
    If your problem is solved, then please mark the thread as SOLVED

    Sharing is Caring .... spread the knowledge

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    36,259

    Re: Can the name of a range be dynamic?

    It's a very generic question to which the answer is possibly maybe who knows? You could, for example, have a worksheet change event handler monitoring a cell, or cells, where you want to allow the user(s) to name the ranges. When it changes, you can do something ... what that is depends on what you want to happen ... but create/replace a Named Range with its new name. How you provide the link between the cell with new name and the actual range is another question.
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    4,603

    Re: Can the name of a range be dynamic?

    Please Login or Register  to view this content.

  4. #4
    Forum Contributor Grimace's Avatar
    Join Date
    05-04-2009
    Location
    Gold Coast, Australia
    MS-Off Ver
    Excel 2013 and Office 365 Plus
    Posts
    378

    Re: Can the name of a range be dynamic?

    Thanks Trevor ... Apologies if the question seemed generic, I was merely asking if it was possible as I have only ever manually named a range, rather than using a reference from another cell to create the name.

    From your reply I guess the answer is yes

  5. #5
    Forum Contributor Grimace's Avatar
    Join Date
    05-04-2009
    Location
    Gold Coast, Australia
    MS-Off Ver
    Excel 2013 and Office 365 Plus
    Posts
    378

    Re: Can the name of a range be dynamic?

    Thank so much for your helpful reply @jolivanes ... I will work with that as a starting point and see what I can come up with. Appreciate it

  6. #6
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    36,259

    Re: Can the name of a range be dynamic?

    You're welcome, and yes, Iím sure you can do it. As jolivanes has demonstrated, the code to do it is straightforward enough ... you just need something to drive it. That would, typically, be an event handler, or perhaps a button.


    If you are satisfied with the solution(s) provided, please mark your thread as Solved.


    New quick method:
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

    Or you can use this way:

    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save


    You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Populate Dynamic Array from Cell Values and write to Dynamic Range
    By TFiske in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-22-2018, 09:09 AM
  2. [SOLVED] Dynamic Range/Dynamic Chart Using Cell Value for Reference and without CountA
    By kelseygueldalewis in forum Excel General
    Replies: 11
    Last Post: 09-11-2017, 04:52 PM
  3. Match ComboBox with dynamic range, then add Textbox1 to dynamic range
    By Lasse Moe in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-07-2014, 01:26 AM
  4. Dynamic Range Column Chart w/ Dynamic Avg Line (Excel 2007)
    By BrokenBiker in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 10-04-2012, 11:40 AM
  5. Fill Dynamic Range From Dynamic Source Range
    By goss in forum Excel General
    Replies: 2
    Last Post: 03-06-2012, 12:05 PM
  6. Dynamic Range with unused formula messing up x axis on dynamic graph
    By cabybake@yahoo.com in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-02-2006, 04:10 PM
  7. [SOLVED] select dynamic range with dynamic start point
    By Juli in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-30-2005, 08:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1