Results 1 to 2 of 2

Thread: ActiveWindow

  1. #1
    Join Date
    Sep 2005
    Posts
    313

    Unanswered: ActiveWindow

    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.

  2. #2
    Join Date
    Feb 2006
    Posts
    113
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •