Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2004
    Posts
    37

    Unanswered: Cutting and Pasting

    Hi,

    I have found that if I cut anything and hence it is held in the clipboard, then the speed at which macros run (in particular anything that puts information on the screen)slows dramatically.

    Is there a reason for this and can it be resolved?

    Many thanks
    Mike

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    Howdy. It depends on what you are trying to do. Sometimes you don't need the clipboard to accomplish copy/paste.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    Oct 2003
    Posts
    1,091
    Also, if it is screen display problems, then put the following in your code

    Code:
    Application.ScreenUpdaing = False
    
    ' code goes here
    
    Application.ScreenUpdating = True
    This will prevent screen re-draws which can slow the process and can be very annoying for the user.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  4. #4
    Join Date
    Oct 2006
    Posts
    9
    Quote Originally Posted by michaeldavid
    Hi,

    I have found that if I cut anything and hence it is held in the clipboard, then the speed at which macros run (in particular anything that puts information on the screen)slows dramatically.

    Is there a reason for this and can it be resolved?

    Many thanks
    Mike
    Lets see the code, maybe we can speed it up for you

Posting Permissions

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