Formula to get address of selected cell on a worksheet
Hi,
I’m looking for a formula to get the currently selected cell within a worksheet.
No VBA or macros since my client has that disabled.Not the last cell edited since an edit may not occur.It can’t be affected by changes of selection on other worksheets.
This is obviously information that Excel tracks and there is no good reason why it wouldn’t be readily available. (I know there is always the possibility of bad reasons they may keep this information inaccessible, but I’m hoping that isn’t the case.)
Any help would be appreciated.
Thank you,
John
Hi, I’m looking for a formula to get the currently selected cell within a worksheet.No VBA or macros since my client has that disabled.Not the last cell edited since an edit may not occur.It can’t be affected by changes of selection on other worksheets.This is obviously information that Excel tracks and there is no good reason why it wouldn’t be readily available. (I know there is always the possibility of bad reasons they may keep this information inaccessible, but I’m hoping that isn’t the case.)Any help would be appreciated. Thank you, John Read More