Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2004
    Location
    Singapore
    Posts
    28

    Question Unanswered: Irritating screen refresh when copying values from one workbook to another

    Hi,

    I have a macro which copys values from one workbook to another therefore flipping from workbook to workbook. When copying, the screen keep refreshing and is a real irritation for the eyes.

    So I would like to know if there is any good solution to overcome this problem.

    Thanks & Regards
    oks

  2. #2
    Join Date
    Jan 2004
    Location
    Aberdeen, Scotland
    Posts
    1,067
    Hi oks

    All you need is at the start of the process put in the line

    applicaiotn.screenupdating = false

    at the end

    Application.ScreenUpdating = True

    as you can probably tell this stops the screen updating, with the added bonus of helping your code run faster

  3. #3
    Join Date
    Jun 2004
    Location
    Singapore
    Posts
    28
    Thanks so much.
    Finally, I don't have to strain my eyes.

Posting Permissions

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