after i execute a macro the visble portion
of the screen is at the bottom of the sheet
example row 200 is showing. how do i change
this so that row 1 is showing?

Range("A1").Select

However unless you really need to scroll down the sheet when running the
macro, it might be better (and faster) to change the code so as not to
select ranges as your macro runs. Also turn off screen updating. It really
depends on your code and what you are trying to do.


--
Cheers
Nigel



"Pete" wrote in message
...
after i execute a macro the visble portion
of the screen is at the bottom of the sheet
example row 200 is showing. how do i change
this so that row 1 is showing?