I have an excel spreadsheet for a rugby competition with multiple sheets that is running a vba code to sort group tables automatically when match results are entered and then return which teams progress to the next round. The vba code to sort the teams works. However, there is an issue with then using the scrollbar to select an input cell. The cell selected is always the one which would be in the original view and not the view I'm in. Example: If A1 is in the top left corner of the screen and then I scroll to make AB11 the top left cell. I would then select AB11 and the computer would instead select A1. How do I amend the vba code to fix?
Solved by O. L. in 22 mins