Creating a 'down' command in a macro

Cell A10 has the range name TEST
Today I want define Cell A11 as having the range name TEST.
A few days later I will want to define Cell A12 as having the range name TEST.


In 'long hand',I could teach it a macro that says :-

GOTO RANGE NAME TEST
DELETE RANGE NAME TEST
DOWN
CREATE RANGE NAME TEST


However the DOWN is permanently interpreted as go to A11, and so would not work as a macro unless it is edited each time.

Any solutions?

Brilliant

Bob Phillips said:

Code:

    Range("Test").Offset(1, 0).Name = "Test"

Click to expand...

Works perfectly. Many thanks.
I'll now investgate the 'offset' funtionality