Recently if using the name box and I want to select a cell range located in a different sheet and said sheet is located within the same workbook let's say I am currently in "Sheet1" and I want to select a cell range in "sheet2" (Cells A1:A10)
In the past I have been able to type "Sheet2!A1:A10" into the name box and excel will take me to that sheet and select cells A1:A10, recently doing said thing will correctly take me to the desired sheet but only selects the first cell not the range.
This problem has made macros and formulas I've set up in the past work incorrectly. Most other computers in our office are not having the same problem, but I was able to recreate this problem on 1 other machine. All computers mentioned here are running excel 2019. I even ran an update to see if it would remedy my problem and no such luck.