Cutting and Pasting

michaeldavid · #1 (**permalink**) 11-09-06, 10:09

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

shades · #2 (**permalink**) 11-09-06, 12:54

Howdy. It depends on what you are trying to do. Sometimes you don't need the clipboard to accomplish copy/paste.

shades · #3 (**permalink**) 11-09-06, 14:06

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.

davesexcel · #4 (**permalink**) 11-11-06, 20:44

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

Internet Services

Web Development

Digital Marketing

Consumer Tech