Clicking into refedit changes screen to bottom of worksheet
 

I have a refedit control that has columns selected in it, example "d:d"
(plus sheet name). When the dialgo first appears, it shows the top rows of
the worksheet. If I click out of the refedit and into another control, for
example a combo box, and then back into the refedit box, the screen shifts
to the bottom of the sheet.

My question: how do I prefent this screen shift from occurring?

Bob