| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select last worksheet in workbook
Hello all,
Is there a way to simply select the last worksheet in a workbook regardless of its name? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Select last worksheet in workbook
Define last. The right most tab? The last sheet created? ...?
-- HTH... Jim Thomlinson "TimT" wrote: Hello all, Is there a way to simply select the last worksheet in a workbook regardless of its name? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Select last worksheet in workbook
Tim,
Try something like With ThisWorkbook.Worksheets .Item(.Count).Select End With -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "TimT" wrote in message ... Hello all, Is there a way to simply select the last worksheet in a workbook regardless of its name? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Select last worksheet in workbook
The right most tab.
"Jim Thomlinson" wrote: Define last. The right most tab? The last sheet created? ...? -- HTH... Jim Thomlinson "TimT" wrote: Hello all, Is there a way to simply select the last worksheet in a workbook regardless of its name? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Select last worksheet in workbook
Chips code will do it for you...
-- HTH... Jim Thomlinson "TimT" wrote: The right most tab. "Jim Thomlinson" wrote: Define last. The right most tab? The last sheet created? ...? -- HTH... Jim Thomlinson "TimT" wrote: Hello all, Is there a way to simply select the last worksheet in a workbook regardless of its name? |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Select last worksheet in workbook
Chip thanks,
So if I wanted to find the last tab (furthest to the right) and reference that sheet in the following line of code: Sheets("LastTab").Name = "Tmp_PartnerContact" ....so I can change it, how would that be referenced? "Chip Pearson" wrote: Tim, Try something like With ThisWorkbook.Worksheets .Item(.Count).Select End With -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "TimT" wrote in message ... Hello all, Is there a way to simply select the last worksheet in a workbook regardless of its name? |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Select last worksheet in workbook
Sheets("LastTab").Name = "Tmp_PartnerContact"
Sheets(Sheets.count).Name = "Tmp_PartnerContact" -- Regards, Tom Ogilvy "TimT" wrote in message ... Chip thanks, So if I wanted to find the last tab (furthest to the right) and reference that sheet in the following line of code: Sheets("LastTab").Name = "Tmp_PartnerContact" ...so I can change it, how would that be referenced? "Chip Pearson" wrote: Tim, Try something like With ThisWorkbook.Worksheets .Item(.Count).Select End With -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "TimT" wrote in message ... Hello all, Is there a way to simply select the last worksheet in a workbook regardless of its name? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| select data and write results to new worksheet in same workbook | Excel Discussion (Misc queries) | |||
| Using Dialog to select a Workbook, Worksheet and Range | Excel Programming | |||
| In Excel 2000, How do you select the whole of a worksheet (Select. | Excel Discussion (Misc queries) | |||
| In Excel 2000, How do you select the whole of a worksheet (Select. | Excel Discussion (Misc queries) | |||
| Select other workbook to select data in a macro. | Excel Programming | |||
Linear Mode
