Is there a way of getting the name of the highlight cell?
I want a cell to get the name of the highlighted cell.
Ex. if I was on C13 cell for instance (not in edit mode), I want let's say F3 to have C13 displayed on recalculation. If I changed the highlighted cell to C15 and recalculate, cell F3 would now show C13.
any ideas.. this maybe an easy one, but I;m not all the greatest in excel..
Thanx
Tim C
I want a cell to get the name of the highlighted cell.
Ex. if I was on C13 cell for instance (not in edit mode), I want let's say F3 to have C13 displayed on recalculation. If I changed the highlighted cell to C15 and recalculate, cell F3 would now show C13.
any ideas.. this maybe an easy one, but I;m not all the greatest in excel..
Thanx
Tim C