Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
smi smi is offline
external usenet poster
 
Posts: 9
Default Select sheet

Please help,
What is the command for select the sheet before last sheet? I am using Excel
97 with WIN 95.
Thank you for your time.

Long


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 550
Default Select sheet

Long,

sheets(sheets.count -1).select

John


"smi" wrote in message
...
Please help,
What is the command for select the sheet before last sheet? I am using

Excel
97 with WIN 95.
Thank you for your time.

Long




  #3   Report Post  
Posted to microsoft.public.excel.programming
smi smi is offline
external usenet poster
 
Posts: 9
Default Select sheet

Thank you John.


"John Wilson" wrote in message
...
Long,

sheets(sheets.count -1).select

John


"smi" wrote in message
...
Please help,
What is the command for select the sheet before last sheet? I am using

Excel
97 with WIN 95.
Thank you for your time.

Long






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Alternate Row Select in Sheet 1 then Paste to Sheet 2 Steevo Excel Worksheet Functions 4 December 5th 08 06:45 PM
Define sheet name then select sheet merry_fay Excel Discussion (Misc queries) 3 December 13th 07 01:23 PM
How do I select price from sheet.b where sheet.a part no = sheet.b Sonny Excel Worksheet Functions 4 April 4th 06 05:08 PM
Use Sheet CodeNames to Select Sheet in Different Workbook Randy Excel Discussion (Misc queries) 1 June 10th 05 12:17 AM
Macro, select Sheet "Number", NOT Sheet Name DAA Excel Worksheet Functions 4 November 30th 04 05:29 PM


All times are GMT +1. The time now is 07:33 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"