Insert worksheet after last irrespective of name

Posted by Barry Ward on August 16, 2001 12:26 AM

Can I insert a worksheet after the last sheet without naming the last sheet?

Posted by mseyf on August 16, 2001 6:48 AM

Try:

ActiveWorkbook.Sheets.Add after:=Worksheets(Worksheets.Count)

HTH

Mark

Posted by Barry Ward on August 17, 2001 4:38 AM

Thanks, that works a treat