Results 1 to 5 of 5
  1. #1
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    VBA - ScrollIntoView (XL 97)

    Anyone have code for something like the XL2K+ ScrollIntoView method that will work on XL97? I don't need all of the capabilities of ScrollIntoView, I just need to scroll so that the first row of a given range is at the top of the screen. TIA , Sam
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: VBA - ScrollIntoView (XL 97)

    Does this command do what you want:

    <pre>Application.Goto Reference:=Range("myRange"), _
    scroll:=True</pre>


    Steve

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA - ScrollIntoView (XL 97)

    The following code will select cell C100 and scroll it to the top left corner of the window:

    <pre> Application.Goto Reference:=Range("C100"), Scroll:=True
    </pre>

    Legare Coleman

  4. #4
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: VBA - ScrollIntoView (XL 97)

    You guys are awesome, 4 seconds and you solved my problem! Thanks!
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: VBA - ScrollIntoView (XL 97)

    Glad we could help.
    <img src=/S/whisper.gif border=0 alt=whisper width=29 height=17>I think it was more 4 minutes not 4 seconds based on posting times... <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    Steve

Posting Permissions

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