Consulting

Results 1 to 3 of 3

Thread: Scrolling issue, going too far

  1. #1
    VBAX Regular
    Joined
    Dec 2009
    Posts
    11
    Location

    Scrolling issue, going too far

    my excel workbook for some stupid reason is all screwed up. i have a list of over 2,000 contacts on 1 sheet. when i grab the little thing on the scroll bar and move it up and down it scrolls way too fast. i'll start at row 2 and move it down one notch and it's a 1,450. Does anybody know how to fix this? thanks.

    <-- this is definitely how i feel
    Last edited by Aussiebear; 06-12-2010 at 03:22 PM. Reason: Clean up the thread a little bit

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    Sounds like you have the usedrange going too far. See if this helps http://www.contextures.com/xlfaqApp.html#Unused
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  3. #3
    Site Admin
    Urban Myth
    VBAX Guru
    Joined
    May 2004
    Location
    Oregon, United States
    Posts
    4,940
    Location
    Hi there,

    As you've probably noticed I changed the title of your thread. Please refrain from using profanity, or profanity-like, topic headings. Instead, keep it meaningful to your purpose. Remember, the thread title is the first thing looked at by people trying to help you resolve your issue(s), and may steer them clear or bring them in.

Posting Permissions

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