ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Switching Sheets (https://www.excelbanter.com/excel-programming/300990-switching-sheets.html)

Roger

Switching Sheets
 
I have a button on one and I called it "NEXT", because I want to go to the next sheet.

I can go to the next sheet but I can make it go to the top of the shhet.

How can I do this?

ROGER

JulieD

Switching Sheets
 
Hi Roger

you need the line
Range("A1").select
in after you go to the new sheet

Hope this helps
Cheers
JulieD

"RogeR" wrote in message
...
I have a button on one and I called it "NEXT", because I want to go to the

next sheet.

I can go to the next sheet but I can make it go to the top of the shhet.

How can I do this?

ROGER





All times are GMT +1. The time now is 09:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com