Notices
Computer & Technology Related Post here for help and discussion of computing and related technology. Internet, TVs, phones, consoles, computers, tablets and any other gadgets.

visual basic for excel question

Thread Tools
 
Search this Thread
 
Old 12 May 2002, 09:27 PM
  #1  
airhead
Scooby Regular
Thread Starter
 
airhead's Avatar
 
Join Date: Oct 2000
Posts: 184
Likes: 0
Received 0 Likes on 0 Posts
Question

if you are on (say) the third sheet of an excel spreadsheet, you can select the forth sheet by using the command
activesheet.next.select

what is the command to select the first sheet.
this presumes that you don't know what it is called.


ta.
Old 12 May 2002, 11:36 PM
  #2  
David_Wallis
Scooby Regular
 
David_Wallis's Avatar
 
Join Date: Nov 2001
Location: Leeds - It was 562.4bhp@28psi on Optimax, How much closer to 600 with race fuel and a bigger turbo?
Posts: 15,239
Likes: 0
Received 1 Like on 1 Post
Post

Sheets(1).Select

David
Old 13 May 2002, 02:17 AM
  #3  
airhead
Scooby Regular
Thread Starter
 
airhead's Avatar
 
Join Date: Oct 2000
Posts: 184
Likes: 0
Received 0 Likes on 0 Posts
Post

perfect.

problem solved.
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
Mattybr5@MB Developments
Full Cars Breaking For Spares
28
28 December 2015 11:07 PM
Frizzle-Dee
Essex Subaru Owners Club
13
01 December 2015 09:37 AM
PetrolHeadKid
Driving Dynamics
10
05 October 2015 05:19 PM
bluebullet29
General Technical
9
05 October 2015 02:17 PM
Pro-Line Motorsport
Car Parts For Sale
2
29 September 2015 07:36 PM



Quick Reply: visual basic for excel question



All times are GMT +1. The time now is 02:37 AM.