Hi,

In VB of the Excel,

I want to setup like this,

if the ActiveWindow cannot show the selected cell at all (maybe show half of it), then ActiveWindow.ScrollColumn = 8

But, I don't know how to check whether or not the selected cell size is shown in the active window.

Please let me know, thanks.

Do comparisons as appropriate of something like
activewindow.width and activecell.left, or, activecell.left + activecell.width
and
activewindow.height and activecell.top, or, activecell.top + activecell.height

HTH
Fazza