Excel 2003 on WinXL
I have a workbook with several named sheets.
I wish to programatically add a new named sheet after a named existing sheet
(lets call it MySheet) without Activating or selecting MySheet.
AddSheets After... doesnt seem to allow this.
--
donwb

Worksheets.Add(After:=Worksheets("MySheet")).Name = "NewSheet"


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"donbowyer" <(E-Mail Removed)> wrote in message
newsC6039DA-A807-438E-B8E4-(E-Mail Removed)...
> Excel 2003 on WinXL
> I have a workbook with several named sheets.
> I wish to programatically add a new named sheet after a named existing
> sheet
> (lets call it MySheet) without Activating or selecting MySheet.
> AddSheets After... doesnt seem to allow this.
> --
> donwb

Thanks Bob - it was the syntax that evaded me
--
donwb


"Bob Phillips" wrote:

> Worksheets.Add(After:=Worksheets("MySheet")).Name = "NewSheet"
>
>
> --
> HTH
>
> Bob
>
> (there's no email, no snail mail, but somewhere should be gmail in my addy)
>
> "donbowyer" <(E-Mail Removed)> wrote in message
> newsC6039DA-A807-438E-B8E4-(E-Mail Removed)...
> > Excel 2003 on WinXL
> > I have a workbook with several named sheets.
> > I wish to programatically add a new named sheet after a named existing
> > sheet
> > (lets call it MySheet) without Activating or selecting MySheet.
> > AddSheets After... doesnt seem to allow this.
> > --
> > donwb
>
>
>