Asking

[accessman2]

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.

 

[Jimmy the Hand]

Do you insist on using "ActiveWindow.ScrollColumn = 8"?

Maybe "ActiveCell.Show" will do?