View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default New worksheet position

Worksheets.Add After:=Sheets(1)


Gord Dibben MS Excel MVP

On Tue, 29 Jul 2008 11:53:37 -0700, Jim
wrote:

Quick question. How do I set the position of a new tab? When i create a new
sheet, it is in the 1st position, i want it to be in the 2nd position. thanks