Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2011
    Posts
    82

    Unanswered: Code to remember active cell name

    Hello

    I have been searching the internet, but with no luck, and have tried several technqiues which have not worked yet

    I am looking for some code which will remember the active cell address by calling it a name and then code that will return to the named cell

    Could anyone kindly help me on this matter?

    Kind Regards
    Helen

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Are you talking about assigning the cell address to a variable?
    Code:
    Dim x As Range
        x = Cells(1, 1)
    George
    Home | Blog

  3. #3
    Join Date
    Jun 2014
    Posts
    10
    Quote Originally Posted by gvee View Post
    Are you talking about assigning the cell address to a variable?
    Code:
    Dim x As Range
        x = Cells(1, 1)
    thanks maybe i also try this.

Posting Permissions

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