Can I reference the currently selected cell in a formula?

  • Thread starter Thread starter Ed from AZ
  • Start date Start date
E

Ed from AZ

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
 
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
 
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


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
 
D'oh - INDIRECT!! I keep forgetting that. "CELLS" - a VBA slip-up.

Thanks again, Bernie.

Ed
 
Back
Top