Add Range Name

[KeithB]

I have a list of Dynamic Range Names Staff1 to Staff20. As a new member of staff is added I want to add a range name using that persons name. I am using the following code to add the range name.
NewName is calculated and = Staff1 for the first name added, staff2 for the next etc.
The range name is created ie. Keith but when looking at the range names the refers to box shows ="Staff1"How do I get rid of the parenthesis?

Please Login or Register  to view this content.

[royUK]

I don't get hem using this variation on your code. It's hard to check without your workbook.

Please Login or Register  to view this content.

[KeithB]

I don't get hem using this variation on your code. It's hard to check without your workbook.

Please Login or Register  to view this content.

Thanks, that added the name without the parenthesis, however the range Staff1 was a dynamic range but the range name in my code only referred to a single cell. I found some code on another site and have modified it and put it in a module and now everything is fine. After creating the range name i run the function to convert it to a dynamic range. The function is:-

Please Login or Register  to view this content.

[royUK]

Thanks for sharing your answer, maybe you could add a link to the web site.