Resolved: Capture active cell location

[project_man]

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

 

[Ricky Morris]

Before you start unhiding stuff do:

curr_addr = Activecell.Address

When you're done do:

Range(curr_addr).Select