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.

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.

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

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

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.