Thanks for any help.
I have a worksheet where the user changes the date in two cells. After
changing the date in the first cell, the user clicks Data>Refresh Data (or
clicks the Refresh data button), and then, typically with the mouse, selects
the second cell, and changes the data there, and hits enter (no need to hit
Refresh data for the second one). I would like to write some code where after
the user clicks Refresh Data, the second date cell automatically becomes the
selected cell (without the user having to select it with the mouse, or arrow
keys). So I can speed up this process, as it is done everyday. I know it
doesn't take a lot of time with the mouse, but a little bit of speed doesn't
hurt.
I figure this would be done best with some kind of event code, maybe using
events with the QueryTable object (when I record a macro of clicking refresh
Data, the code is: Selection.QueryTable.Refresh BackgroundQuery:=False).
Is this the right path to be heading? Just want to check before I try this.
Thanks again.