Thread: How can I move a sheet to the end of the workbook in VB?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jon Davie Jon Davie is offline
external usenet poster
  
Posts: 1
Default How can I move a sheet to the end of the workbook in VB?
I know how to move the sheets around:

Sheets("1996").Select
Sheets("1996").Move After:=Sheets(2)

But how can I move the sheet to the end of the book if the number of sheets
in the book changes often?
Reply With QuoteReply With Quote