find activecell in Excel - not via VBA

Spock's Brain · Apr 16th, 2002, 12:51 PM

Is there a function in Excel that will return the active cell? Without going thru VBA?
I would like the value in B1 to change based on the current active cell position.

I seem to remember such a function in Lotus but that was some time ago & I could be wrong.

Russell Hauf · Apr 16th, 2002, 01:17 PM

Don't think so.

Mark O'Brien · Apr 16th, 2002, 01:23 PM

Out of interest, what would you apply such a function to, if such a function existed?

Apr 16th, 2002, 01:23 PM	#3
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	Out of interest, what would you apply such a function to, if such a function existed? __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

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

Apr 16th, 2002, 12:51 PM	#1
Spock's Brain New Member Join Date: Mar 2002 Posts: 18	Is there a function in Excel that will return the active cell? Without going thru VBA? I would like the value in B1 to change based on the current active cell position. I seem to remember such a function in Lotus but that was some time ago & I could be wrong.

Apr 16th, 2002, 01:17 PM	#2
Russell Hauf MrExcel MVP Join Date: Feb 2002 Location: Portland, OR USA Posts: 1,374	Don't think so.