Hello everyone,

Here is my problem:

In a column I have a series of 300 numbers ranging from C6 to C305.
I have appointed a range of cells in this column, ranging from C6 to C112, "Abcissa".
I would like, using a macro, delete "Abcissa" rename to another range of cells in the same column, which would, for example, from C6 to C255, always "Abcissa".
"Abcissa" is the name of the range "C6: Cx" where x belongs to [6, 305].

In cell G6 is the address of the variable range of cells, in the form of:
"C6: C112" (in the first case), then "C6: C255" (in the latter).

I tried the following:

Sub Macro1()

Dim Cellule As Range
Set Cellule = Range ("G6"). Value
ActiveWorkbook.Names ("Abcissa"). Delete
Range (Cellule.Address). Name = "Abcissa"

End Sub

But it did not work...

A big thank you for any help.

PS: excuse me for my bad english.