Page view on row 77 after exiting macro back to sheet

[Steve001]

Hi All,

Bit confused with this. When i exit my macro's and return back to my active sheet my page view is around row 77.
how do i get back to showing the top of the sheet ie row 1

i am using the following

Sheets("Sheet 1").Select
Range("A3").Select

the page view is at row 77 and A3 is selected ??

Can you please put comments on as i am still a noob and finding my feet, i like to know why things happen rather than just blindly copying code

regards

Steve

 

[Fluff]

i like to know why things happen

In that case it would help if you posted your complete code.
It's always best to remove the problem, rather than cure it.

Also when posting code, please use code tags, the # icon in the reply window

 

[Steve001]

Hi Fluff,

Cannot really post the entire contents as this contains commercially sensitive information.
I know it make it difficult to solve

Steve

 

[Fluff]

In that case I cannot tell why you are ending up on row 77.
It may be that somewhere in the code you are selecting a cell on row 77