I wish to have a "goto" function that brings the sheet to a cell named 'A_A' or 'B_B', which changes its row (but not column) as the list is further populated. But the names don't "stick" to the cells. Renamed the range from '$A$1' to '$A1', but that doesn't do it.
It's for a button function that gets me the the starting letter of an alphabetical list