Hi
add the following lines
sub your_macro
application.screenupdating=false
'your existing code
application.screenupdating = True
end sub

Note: Though the macro recorder creates a lot of 'Select' statements
they're in most cases not required but slow down your macro. e.g. a
statement like the following:

with activesheet
Range("B1").select
Selection.value="value"
end with

could be shortened to:
Activecell.Range("B1").value="value"


--
Regards
Frank Kabel
Frankfurt, Germany


I was curious to know if there was an option to not show the work a
macro button I recorded is doing. When you click the button the sheet
jumps around a lot and then stops. I would like it not even bother
jumping around and just stay showing one part of the excel sheet
while
it does its work.

If its possible please let me know!

Thanks

ERic


---
Message posted from http://www.ExcelForum.com/