MsOf07 Correct scrolling limit-VBForums
Results 1 to 4 of 4

Thread: Correct scrolling limit

  1. #1

    Thread Starter
    Junior Member
    Join Date
    Feb 2010
    Posts
    28

    Correct scrolling limit

    Dear Everyone,

    I have a worksheet having data to column AMR. When I make columns shown and hidden several time using VBA, the horizental scroll bar of Excel has a problem as followed:

    1. To see the column AMR, I have to drag the scroll bar very little (left image).
    2. If I put the scroll bar right-most position, I become to hit column UVT (right image). There is no data from columns AMS to UVT.

    How can I reset my worksheet shows column AMR when I put the scroll bar right-most position? Worksheet.ScrollArea is not of solution. I already tested with no result.

    Reply would be appreciated.
    Attached Images Attached Images   
    Last edited by skparkcn; May 12th, 2012 at 11:09 AM.

  2. #2
    Just a Member! seenu_1st's Avatar
    Join Date
    Aug 2007
    Location
    India
    Posts
    2,158

    Re: Correct scrolling limit

    what abt this
    Code:
    ActiveWindow.ScrollColumn = 4 'col number
    edited: Column number of AMR = Cells(1,"AMR").Column
    Last edited by seenu_1st; May 13th, 2012 at 12:13 AM.
    Seenu

    If this post is useful, pls don't forget to Rate this post.
    Pls mark thread as resolved once ur problem solved.
    ADO Tutorial Variable types SP6 for VB6, MsFlexGrid fast fill, Sorting Algorithms


  3. #3

    Thread Starter
    Junior Member
    Join Date
    Feb 2010
    Posts
    28

    Re: Correct scrolling limit

    Dear seenu_1st

    It is just scroll to destinated column, and my problem is still not solved. I suppose, because of this problem, my VBA code cannot be excused. If I copy the data to new sheet and run VBA code, there is no problem for several times, but finally hit error.

  4. #4
    Just a Member! seenu_1st's Avatar
    Join Date
    Aug 2007
    Location
    India
    Posts
    2,158

    Re: Correct scrolling limit

    it works for the active window, so activate ur sheet and scroll, if u dont want to display the sheet changes, set screen updates = false b4 execute the set it to true.
    Seenu

    If this post is useful, pls don't forget to Rate this post.
    Pls mark thread as resolved once ur problem solved.
    ADO Tutorial Variable types SP6 for VB6, MsFlexGrid fast fill, Sorting Algorithms


Posting Permissions

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



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.