A question regarding Macros

[DangerMouse114]

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

If its possible please let me know!

Thanks

ERi

 

[Frank Kabel]

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"

 

[Dave Peterson]

Typo alert...

I'm pretty sure that Frank meant:

Activesheet.Range("B1").value="value"
instead of:
Activecell.Range("B1").value="value"

 

[Frank Kabel]

Thanks Dave