Resolved: Capture active cell location

project_man · May 7th, 2002, 09:40 AM

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 · May 7th, 2002, 09:48 AM

Before you start unhiding stuff do:

curr_addr = Activecell.Address

When you're done do:

Range(curr_addr).Select

May 7th, 2002, 09:48 AM	#2
Ricky Morris Board Regular Join Date: Mar 2002 Posts: 363	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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 7th, 2002, 09:40 AM	#1
project_man New Member Join Date: May 2002 Location: Toronto, Canada Posts: 12	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 ]