Code For Changing Named Ranges

[brettvba]

Anyone have any code for changing a named range
eg StartCell and if possible refering it to a variable?

[Tom Schreiner]

This may or may not help you.
The code names a range based upon the cell contents. Maybe you can pickup on the syntax.
I do not know if this is the easiest way to name a range, it's just the first way I found that works.
Tom
See last post, toward the end if the procedure.

http://www.mrexcel.com/board/viewtop...c=7082&forum=2

[brettvba]

yeah no I was just after code to rename a current named range I have any Ideas?

[Tom Schreiner]

Sorry, I misunderstood you.
This will rename a current named range...

ActiveWorkbook.Names("YourRangeName").Name = "NewRangeName"


Tom

[Ivan F Moala]

On 2002-05-14 18:54, brettvba wrote:
yeah no I was just after code to rename a current named range I have any Ideas?

Hi Brettvba

Try something like this;

Sub ReName_NamedRg()



With ActiveWorkbook

    'add named range

    .Names.Add Name:="Test", RefersTo:="=" & ActiveSheet.Name & "!$A$1:$A$10"

End With



End Sub

Tom bet me to it!
_________________
Kind Regards,
Ivan F Moala
Have a Nice day

[ This Message was edited by: Ivan F Moala on 2002-05-14 19:26 ]

[brettvba]

Thanks Tom

[Tom Schreiner]

'Tis rare Ivan!

[brettvba]

Thanks Guys