do not show
 

I have codes which take information from one sheet and move it to another,
is there a way that when the macro is running it moves the data with out
showing all the movement?

do not show
 

Hi,

Try adding this line of code at the begining of yours

Application.ScreenUpdating = False

rgds

"Miree" wrote:

I have codes which take information from one sheet and move it to another,
is there a way that when the macro is running it moves the data with out
showing all the movement?

do not show
 

Be sure to reset to =true and the end. Also, you need NOT select to
copy/move data

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Anthony" wrote in message
...
Hi,

Try adding this line of code at the begining of yours

Application.ScreenUpdating = False

rgds

"Miree" wrote:

I have codes which take information from one sheet and move it to
another,
is there a way that when the macro is running it moves the data with out
showing all the movement?