Re: Can I reference the currently selected cell in a formula?

D'oh - INDIRECT!! I keep forgetting that. "CELLS" - a VBA slip-up.

Thanks again, Bernie.

Ed


On Mar 26, 12:12 pm, "Bernie Deitrick" <deitbe @ consumer dot org>
wrote:
Ed,

Two errors there: it is CELL, not CELLS, and you need an INDIRECT

=P4394-OFFSET(INDEX(INDIRECT(CELL("Address")),1,1),0,1,1,1)

would be the correct syntax, though only you can tell if it is the correct formula.

HTH,
Bernie
MS Excel MVP

"Ed from AZ" <prof_ofw...@xxxxxxxxx> wrote in messagenews:0db21469-4d7e-4c55-a649-662e5379566d@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Thanks, Bernie!  Works great!

Ah - can I use OFFSET with that, too?  I tried using
=P4394-OFFSET(INDEX(CELLS("address"),1,1),0,1,1,1)
but got an error.

Ed

On Mar 26, 10:39 am, "Bernie Deitrick" <deitbe @ consumer dot org>
wrote:



Ed,

Yes.

=A50 - CELL("Contents")

HTH,
Bernie
MS Excel MVP

"Ed from AZ" <prof_ofw...@xxxxxxxxx> wrote in
messagenews:bd9bbce0-3c8f-4ccf-b403-5ae8deaa0792@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

I have to do some calculations over a large work***. 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- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

.