is ther any way (i.e. function) to show the address of a certain cell in Excel sheet, even after the user inserts or deletes rows or columns or sorts the sheet? For instance, if a cell address is G10, I see this string (“G10”) in another cell, and after inserting a column between A and B, the string changes to “H10”.
I appreciate any help.