How do I get a GoTo statement to use the contents of a cell in the Reference, not the cell itself.
Example: Cell R8C1 contains a cell address "xy23" . This address is dynamic as it refers to an alphabatized list that changes automatically as data is added. In this case the location of the beginning of all data starting with the letter F.
How do I get a GoTo reference to use the cell value, not the cell itself.
In other words, how do I get the statment Application.Goto Reference:="R8c1" to use the value of the cell (xy23) not the cell itself. Such that when the command is executed it will GoTo cell "xy23" (the beginning of the F entries). The reference in the cell changes automatically as data is added and resorted.
Currently, the only way I have is to manually change the GOTo reference (e.g. xy23) in the macro manually. As there are 26 letters to the alphabet, I would have to change up to 26 GoTo statements everytime a new entry is made in the spreadsheet, depending on where the new entry falls in the alphabet.
Suggestions?
Bookmarks