Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Resolved: Capture active cell location

  1. #1
    New Member
    Join Date
    May 2002
    Location
    Toronto, Canada
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi,

    I think this is a Newbie question, but then, that would be me. I am trying to capture the current cell location in a macro that hides and displays many rows. I would like the user to end up with the same view (i.e. at the same cell) they had before they wanted to see the hidden detail. In my current routine, they end up at the last of the unhidden rows which can be many pages from where they wanted to see the detail.

    If I can capture the row and column information at the start of the sub, I can go back to that same cell at the end of routine. I think this is just one line of code, but I do not know it.

    Thanks,
    Ron

    [ This Message was edited by: project_man on 2002-05-07 08:43 ]

    [ This Message was edited by: project_man on 2002-05-07 08:53 ]

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Posts
    363
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Before you start unhiding stuff do:

    curr_addr = Activecell.Address

    When you're done do:

    Range(curr_addr).Select
    It's never too late to learn something new.

    Ricky

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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