View Single Post
  #2   Report Post  
Kassie
 
Posts: n/a
Default

Why 60 sheets?
You can write 60 little macros -
Sub Macro1()
Sheets("Sheetn").Select
End Sub

Where "n" = the sheet you want to go to. You can also replace "Sheetn" with
the name of the sheet (In ""). I just don't know how you are going to
remember the names of all these macro's! You can use Ctrla to Ctrlz and
CtrlShifta to CtrlShiftz, but that is only 56.

Why 60 sheets? How big is each sheet?

Wow
"Supreme Grace" wrote:

I would like to have more than 60 sheets in a excel file, but going to
particular sheet is very difficult for me. so i want to search a particular
sheet or to arrang the sheets in alphabetical order