View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default 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?