You mean in the display to the user, right? I just did a little
experimenting, and Activate works. At least, I told my program to do this:

ActiveSheet.Cells(100, 100).Activate

....and the display jumped straight to that spot. Seems to me it would work
with Window.Selection too.

I didn't test this, but I suppose it may be that once you scroll away from
the selection without deactivativing it, Activate won't jump back to it
again. But that's easy; you could just Activate something else and then
Window.Selection.Activate again.

--- "Won" wrote:
How can I get Zoom window to display the selection only?

I¹d prefer this to apply to the whole workbook regardless of which worksheet
is displaying