Can I reference the currently selected cell in a formula?

Giganews Newsgroups
Subject: Can I reference the currently selected cell in a formula?
Posted by:  Ed from AZ (prof_ofwh…@yahoo.com)
Date: Thu, 26 Mar 2009

I have to do some calculations over a large worksheet.  Rather than
constantly adjust my formulas to reflect the new values, I'd like to
be able to simply enter something like:

  = A50 - Selection

and then simply recalculate (F9?) when I make another selection.  Is
this possible?

Ed

Replies