Results 1 to 4 of 4

ActiveWindow.ScrollRow = 76 (Do I need this?)

This is a discussion on ActiveWindow.ScrollRow = 76 (Do I need this?) within the Excel Questions forums, part of the Question Forums category; Good Morning, I have created macros in which I am getting good enough to edit and modify them using the ...

  1. #1
    Board Regular
    Join Date
    Apr 2006
    Location
    SOUTH TEXAS
    Posts
    67

    Default ActiveWindow.ScrollRow = 76 (Do I need this?)

    Good Morning,
    I have created macros in which I am getting good enough to edit and modify them using the VBA editor. Many times there is this code created by the macro:
    ActiveWindow.ScrollRow = 76
    ActiveWindow.ScrollRow = 54
    ActiveWindow.ScrollRow = 44
    ActiveWindow.ScrollRow = 33
    ActiveWindow.ScrollRow = 12
    ActiveWindow.ScrollRow = 1

    sometimes it might go for a page or more incrementing the number. Can I take this out? It just makes for terrible reading!

    Thanks,

    Al

  2. #2
    Board Regular Norie's Avatar
    Join Date
    Apr 2004
    Location
    Stirling
    Posts
    66,050

    Default

    Al

    Yes you can take it out.

    When you record a macro everything you do, including scrolling, is recorded.
    If posting code please use code tags.

  3. #3
    MrExcel MVP erik.van.geit's Avatar
    Join Date
    Feb 2003
    Location
    Belgium 3272 Testelt
    Posts
    17,765

    Default

    Hi,

    YES! you can
    these are only navigational commands
    they do no operations at all

    SELECT can be avoided to
    all this slows down the process considerably

    kind regards,
    Erik

  4. #4
    Board Regular
    Join Date
    Apr 2006
    Location
    SOUTH TEXAS
    Posts
    67

    Default

    Thanks guys.

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com