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?