View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JulieD JulieD is offline
external usenet poster
 
Posts: 618
Default 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