Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 3 of 3 FirstFirst 123
Results 21 to 23 of 23

Thread: Delete row after 120 days

  1. #21

    Join Date
    Mar 2002
    Posts
    372
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-22 23:22, Ivan F Moala wrote:

    Last thing -- the Application.ScreenUpdating = True is unnecessary at the end of the routine, as Excel defaults back to true at the End Sub.

    Thanks for your post,
    Jay
    Jay....screenupdating doesn't default back to true.

    Ivan
    [/quote]


    Oh?
    According to Microsoft it does, except for one exception.
    The exception results from a situation that's not a common one.
    For details see Article Q213606 in the MS Knowledge Base.

  2. #22
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-22 23:38, C. O. Jones wrote:
    On 2002-03-22 23:22, Ivan F Moala wrote:

    Last thing -- the Application.ScreenUpdating = True is unnecessary at the end of the routine, as Excel defaults back to true at the End Sub.

    Thanks for your post,
    Jay
    Jay....screenupdating doesn't default back to true.

    Ivan

    Oh?
    According to Microsoft it does, except for one exception.
    The exception results from a situation that's not a common one.
    For details see Article Q213606 in the MS Knowledge Base.

    [/quote]

    Yes this is true in that the Screen resets
    (Excel2000+ only) BUT the status for
    screenupdating is still set to False within
    the program....

    Help File States..
    ScreenUpdating Property

    True if screen updating is turned on. Read/write Boolean.

    Remarks

    Turn screen updating off to speed up your macro code. You won't be able to see what the macro is doing, but it will run faster.

    Remember to set the ScreenUpdating property back to True when your macro ends.

    So I genearally always reset this in the program
    especially for backwards compatibilty PLUS
    the fact that most of my routines are called
    from others and may / may not require the screen update.



    Ivan

  3. #23
    Board Regular
    Join Date
    Mar 2002
    Posts
    153
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks everyone I ended up using Jay's, with the screen updated added, thanks to Ivan. Thanks for all the help, great site, lots of people helping each other out

    [ This Message was edited by: AC on 2002-03-23 06:50 ]

Some videos you may like

User Tag List

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
  •