Loop Macro gets progressively slower
Page 2 of 2 FirstFirst 12
Results 11 to 16 of 16

Thread: Loop Macro gets progressively slower
Thanks Thanks: 0 Likes Likes: 0

  1. #11
    Board Regular Michael M's Avatar
    Join Date
    Oct 2005
    Location
    South Western NSW
    Posts
    17,503
    Post Thanks / Like
    Mentioned
    18 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Loop Macro gets progressively slower

    Does it do the same on another PC ??
    Can you upload the workbook to dropbox and post the link back here ?
    Regards
    Michael M
    ---------------------------------------
    The more I learn, the less I seem to know.....A Please and Thank You cost nothing !
    It's easier to debug if we can see the whole macro !
    Home 2007 & 2013

    - Posting guidelines, forum rules and terms of use

    - To download Mr Excel HTML Maker

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes


    [CODE]Place Your Code Here[/CODE]

  2. #12
    Board Regular
    Join Date
    May 2010
    Location
    Laguna Niguel, CA
    Posts
    94
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Loop Macro gets progressively slower

    Good point. I have not tried a different PC. The spreadsheet is proprietary so I cannot share unfortunately.
    Quote Originally Posted by Michael M View Post
    Does it do the same on another PC ??
    Can you upload the workbook to dropbox and post the link back here ?

  3. #13
    Board Regular Michael M's Avatar
    Join Date
    Oct 2005
    Location
    South Western NSW
    Posts
    17,503
    Post Thanks / Like
    Mentioned
    18 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Loop Macro gets progressively slower

    You could put dummy data in it ??
    Regards
    Michael M
    ---------------------------------------
    The more I learn, the less I seem to know.....A Please and Thank You cost nothing !
    It's easier to debug if we can see the whole macro !
    Home 2007 & 2013

    - Posting guidelines, forum rules and terms of use

    - To download Mr Excel HTML Maker

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes


    [CODE]Place Your Code Here[/CODE]

  4. #14
    Board Regular
    Join Date
    May 2010
    Location
    Laguna Niguel, CA
    Posts
    94
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Loop Macro gets progressively slower

    I'd have to considerably change the spreadsheet and formulas because it's too revealing and some proprietary. I will go with your prior recommendation of using a filter instead. That's instantaneous vs. running a loop. I will try to build a shareable sheet workbook if I find time. I appreciate the offer to assist, really.
    Quote Originally Posted by Michael M View Post
    You could put dummy data in it ??

  5. #15
    Board Regular Michael M's Avatar
    Join Date
    Oct 2005
    Location
    South Western NSW
    Posts
    17,503
    Post Thanks / Like
    Mentioned
    18 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Loop Macro gets progressively slower

    DId you try it on another PC ?
    With what your code does, I wouldn't think it's a PC or memory issue !!
    Regards
    Michael M
    ---------------------------------------
    The more I learn, the less I seem to know.....A Please and Thank You cost nothing !
    It's easier to debug if we can see the whole macro !
    Home 2007 & 2013

    - Posting guidelines, forum rules and terms of use

    - To download Mr Excel HTML Maker

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes


    [CODE]Place Your Code Here[/CODE]

  6. #16
    Board Regular Michael M's Avatar
    Join Date
    Oct 2005
    Location
    South Western NSW
    Posts
    17,503
    Post Thanks / Like
    Mentioned
    18 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Loop Macro gets progressively slower

    Another minor change to the pagebreak section.....but I don't think it will change anything, just cleaner

    Code:
    ActiveSheet.ResetAllPageBreaks
        With ActiveWindow.SelectedSheets.HPageBreaks
            .Add Before:=Rows("56:56")
            .Add Before:=Rows("211:211")
            .Add Before:=Rows("428:428")
            .Add Before:=Rows("493:493")
        End With
    Regards
    Michael M
    ---------------------------------------
    The more I learn, the less I seem to know.....A Please and Thank You cost nothing !
    It's easier to debug if we can see the whole macro !
    Home 2007 & 2013

    - Posting guidelines, forum rules and terms of use

    - To download Mr Excel HTML Maker

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes


    [CODE]Place Your Code Here[/CODE]

Some videos you may like

User Tag List

Tags for this Thread

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
  •