Solved: add template after activeSheet

[photon_ed]

Hello, i am having some problems getting this code working. I would like to add a new sheet as a template after the activesheet. Please check codes below and advice. THank you very much.

yours,
Ed

Sheets.Add after Type:="I:\Office\Templates\LansTemplate.xlt"

[Jacob Hilderbrand]

You need to finish the After argument.


Sheets.Add After:=Activesheet, Type:="I:\Office\Templates\LansTemplate.xlt"

[photon_ed]

it works perfectly, thank you for your advise.

yours,
Ed

[Jacob Hilderbrand]

You're Welcome :beerchug:

Take Care