View Full Version : Asking


accessman2
09-13-2006, 02:17 PM
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
10-12-2006, 04:41 AM
Do you insist on using "ActiveWindow.ScrollColumn = 8"?

Maybe "ActiveCell.Show" will do?