Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Feb 2003
    Thanked 0 Times in 0 Posts

    Inconsistent scrollarea results (2000)

    I'm getting inconsistent results with ActiveSheet.ScrollArea

    I have a Forms combobox where a user selects one of several ranges on a wsh to view.
    The event code first hides all rows, unhides the desired rows, adjust column width
    then readjusts the scrollable area in order to keep the user within the desired "window"

    Some selected ranges "freeze" the scolling for some reason. At first I thought that maybe
    the range was only the size of the existing window, but this is only true sometimes.

    See attached file. Any suggestions?
    The Job Class and Job Title ranges are examples of where it does not work properly.
    View the code to open the scroll area and see the event code.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts

    Re: Inconsistent scrollarea results (2000)

    The problem seems to be caused by the line

    Range("AllRows").Rows.Hidden = True

    It doesn't occur if you change it to

    Range("A5:A65536").Rows.Hidden = True

    (i.e. hide ALL rows below the frozen pane at the top)

Posting Permissions

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