Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-13-2012, 02:20 AM
gsrikanth gsrikanth is offline how to go 75 sheet Windows XP how to go 75 sheet Office XP
Competent Performer
how to go 75 sheet
 
Join Date: Dec 2011
Posts: 133
gsrikanth is on a distinguished road
Default how to go 75 sheet

i have workbook with 300 sheet


i have to go to 75 sheet
how i go?
Reply With Quote
  #2  
Old 01-13-2012, 06:12 PM
JBeaucaire JBeaucaire is offline how to go 75 sheet Windows XP how to go 75 sheet Office 2003
Advanced Beginner
 
Join Date: Dec 2011
Posts: 51
JBeaucaire is on a distinguished road
Default

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.
Reply With Quote
  #3  
Old 01-15-2012, 08:13 AM
Catalin.B Catalin.B is offline how to go 75 sheet Windows Vista how to go 75 sheet Office 2010 32bit
Expert
 
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default

Try a macro:
Code:
Sub selectSheet()
Dim i
i = Application.InputBox("Insert sheet number", "Select Sheet", Type:=1)
Worksheets(i).Select
End Sub
Reply With Quote
  #4  
Old 01-17-2012, 11:01 PM
gsrikanth gsrikanth is offline how to go 75 sheet Windows XP how to go 75 sheet Office XP
Competent Performer
how to go 75 sheet
 
Join Date: Dec 2011
Posts: 133
gsrikanth is on a distinguished road
Default

Quote:
Originally Posted by Catalin.B View Post
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.
Reply With Quote
  #5  
Old 01-17-2012, 11:17 PM
Catalin.B Catalin.B is offline how to go 75 sheet Windows Vista how to go 75 sheet Office 2010 32bit
Expert
 
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default

You can mark your thread as solved then
Reply With Quote
  #6  
Old 01-17-2012, 11:24 PM
Catalin.B Catalin.B is offline how to go 75 sheet Windows Vista how to go 75 sheet Office 2010 32bit
Expert
 
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default

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

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to go 75 sheet VLOOKUP in different sheet. santors71 Excel 1 12-07-2011 09:20 AM
how to go 75 sheet Construct a summary sheet by summing up from one or more than one sheet. PRADEEPB270 Excel 1 11-04-2011 03:46 AM
how to go 75 sheet change in the name of sheet accordingly Nirik Excel 3 11-02-2011 06:43 AM
how to go 75 sheet 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

Other Forums: Access Forums

All times are GMT -7. The time now is 06:48 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft