vba - Excel tab sheet names vs. Visual Basic sheet names - Stack Overflow

This a very basic solution (maybe I'm missing the full point of the question). ActiveSheet.Name will RETURN the string of the current tab name (and will reflect any future changes by the user). I just call the active sheet, set the variable and then use i

stackoverflow.com