Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 140
Default go to far left worksheet

I will be grateful for a piece of code to take me to the furtherest worksheet
on the far left (in the base of the workbook where the sheet tabs are
displayed ie, the furtherest tab on the left) in a workbook with many sheets

many thanks
--
with kind regards

Spike
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 718
Default go to far left worksheet

Sheets(1).Select

HTH
--
AP

"Spike" a écrit dans le message de
...
I will be grateful for a piece of code to take me to the furtherest

worksheet
on the far left (in the base of the workbook where the sheet tabs are
displayed ie, the furtherest tab on the left) in a workbook with many

sheets

many thanks
--
with kind regards

Spike



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,058
Default go to far left worksheet

Try:

Sub Macro1()
Worksheets(1).Activate
End Sub
--
Gary''s Student


"Spike" wrote:

I will be grateful for a piece of code to take me to the furtherest worksheet
on the far left (in the base of the workbook where the sheet tabs are
displayed ie, the furtherest tab on the left) in a workbook with many sheets

many thanks
--
with kind regards

Spike

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
how do i switch to a right to left worksheet li New Users to Excel 2 May 5th 10 03:50 AM
Left worksheet function Fiona Excel Worksheet Functions 7 November 14th 07 12:37 PM
worksheet is right-to-left but i want left-to-right...? rose_mina New Users to Excel 1 April 25th 07 12:40 PM
LEFT Worksheet function loren.pottinger Excel Discussion (Misc queries) 11 September 5th 06 09:09 PM
How to change the right-to-left worksheet to left-to-right workshe RAMA Excel Discussion (Misc queries) 1 July 4th 05 01:57 PM


All times are GMT +1. The time now is 08:39 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"