retun active cell value without VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to have a cell equal whatever the active cell contains without
running a macro?
 
Hi Ricy

not really sure what you're after here ... do you want to click in cell C4
and have the value come up in A1, then click in cell D4 and have A1 change
to that value? if so, AFAIK you need to use code to do this.

Cheers
JulieD
 
Ricy wrote...
Is there a way to have a cell equal whatever the active cell contain without
running a macro?
Click to expand...

=CELL("Contents")

is the only candidate, but it won't recalculate automatically. You'
need to press [F9]. If you want the formula to recalculate as yo
change the active cell, you MUST use VBA, specifically
SelectionChange event handler
 
Back
Top