Select the leftmost sheet

shajueasow

Well-known Member
Joined
Oct 7, 2004
Messages
1,926
Hi,
In a workbook, there are many sheets with different sheet names which include names like "products" "01-11-06" etc.
How can it be coded so that the the sheet in the extreme left is selected. That sheet need not be Sheet1 too.
TIA
 

Some videos you may like

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

Watch MrExcel Video

Forum statistics

Threads
1,111,598
Messages
5,541,163
Members
410,543
Latest member
ExcelGlenn
Top