Results 1 to 3 of 3

Thread: Creating a 'down' command in a macro

  1. #1

    Creating a 'down' command in a macro



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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?

  2. #2
    Code:
        Range("Test").Offset(1, 0).Name = "Test"

  3. #3

    Brilliant

    Quote Originally Posted by Bob Phillips View Post
    Code:
        Range("Test").Offset(1, 0).Name = "Test"
    Works perfectly. Many thanks.
    I'll now investgate the 'offset' funtionality

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •