Results 1 to 4 of 4

Thread: Correct scrolling limit

Threaded View

  1. #1

    Thread Starter
    Member
    Join Date
    Feb 2010
    Posts
    36

    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.

Posting Permissions

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



Click Here to Expand Forum to Full Width