chaostheory
Registered User.
- Local time
- Today, 07:06
- Joined
- Sep 30, 2008
- Messages
- 69
I've found it surprisingly hard to figure out how to make the screen focus on the selected cell.
Im running a macro that is updating the datavalidation fields. All the data validation stuff is in column AA1, AB1, AC1, etc. After it's done updating, i want it to select and focus on cell B2 which is where the user will start typing stuff.
range("B2").select
range("B2").activate
application.goto range("B2"), yes
all select the cell, but the cell is off the screen to the left and the screen focus is still around column AA. How can i tell excel to move screen focus to top left for instance or around a particular cell?
Im running a macro that is updating the datavalidation fields. All the data validation stuff is in column AA1, AB1, AC1, etc. After it's done updating, i want it to select and focus on cell B2 which is where the user will start typing stuff.
range("B2").select
range("B2").activate
application.goto range("B2"), yes
all select the cell, but the cell is off the screen to the left and the screen focus is still around column AA. How can i tell excel to move screen focus to top left for instance or around a particular cell?