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 |