how to go 75 sheet

gsrikanth · #1 01-13-2012, 02:20 AM

i have workbook with 300 sheet

i have to go to 75 sheet
how i go?

JBeaucaire · #2 01-13-2012, 06:12 PM

To the left of the sheet tabs are four arrows. RIGHT-CLICK on those arrows and select MORE SHEETS... scroll quickly to 75 and select it.

Catalin.B · #3 01-15-2012, 08:13 AM

Try a macro:

Code:

Sub selectSheet()
Dim i
i = Application.InputBox("Insert sheet number", "Select Sheet", Type:=1)
Worksheets(i).Select
End Sub

gsrikanth · #4 01-17-2012, 11:01 PM

Quote:

Originally Posted by Catalin.B

Try a macro:

Code:

Sub selectSheet()
Dim i
i = Application.InputBox("Insert sheet number", "Select Sheet", Type:=1)
Worksheets(i).Select
End Sub

Thanks CB.

Catalin.B · #5 01-17-2012, 11:17 PM

You can mark your thread as solved then

Catalin.B · #6 01-17-2012, 11:24 PM

In this thread, look in the top of the page for thread tools, under that menu, you will find : mark this thread as solved

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VLOOKUP in different sheet.	santors71	Excel	1	12-07-2011 09:20 AM
Construct a summary sheet by summing up from one or more than one sheet.	PRADEEPB270	Excel	1	11-04-2011 03:46 AM
change in the name of sheet accordingly	Nirik	Excel	3	11-02-2011 06:43 AM
How do I specify which sheet to save as PDF?	shabbaranks	Excel Programming	3	09-14-2011 09:19 PM
copy cell from sheet 2 to sheet 3 macro	slipperyjim	Excel Programming	1	02-18-2010 01:31 AM