I have a spreadsheet displayed to start with at 185%. When I end my input on cell X3 and go to Y3 I want it to automatically zoom 250% and go to A35, then when I press TAB I want it to go down to A43, again TAB from here to A51, and then to A59. Then TAB and it goes to B3 and resizes to 185% OR if required Shift-TAB takes it in the reverse direction, but never back to Y3.
Anyone got a VBA Macro to do this without buttons?
Anyone got a VBA Macro to do this without buttons?