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,280

    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
    I love Jesus

    email Erik

    founder of DRAFT

    my free Addins
    Table-It download & info
    Formula Translator 04

  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