A question regarding Macros
 

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

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

A question regarding Macros
 

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/

A question regarding Macros
 

Typo alert...

I'm pretty sure that Frank meant:

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


Frank Kabel wrote:

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/

--

Dave Peterson

A question regarding Macros
 

Thanks Dave

--
Regards
Frank Kabel
Frankfurt, Germany


Dave Peterson wrote:
Typo alert...

I'm pretty sure that Frank meant:

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


Frank Kabel wrote:

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/