Hello,

I created a Macro which will be used by different users. In this macro I do
add a new sheet which I want to rename.
However based on the regional settings the new sheet will receive a
different name. I.e. in US a new sheet will be named "Sheet1" in Dutch it is
named "Blad1".
Can i directly add a new sheet with a name?

thank you,

Just

You can do it like this:

Sheets.Add after:=Sheets(1)
ActiveSheet.Name = "Results"

This gives the sheet the name Results, and inserts it after the first
sheet.

Hope this helps.

Pete

On May 27, 8:52*am, "Just Merks" <jvw.me...@hccnet.nl> wrote:
> Hello,
>
> I created a Macro which will be used by different users. In this macro I do
> add a new sheet which I want to rename.
> However based on the regional settings the new sheet will receive a
> different name. I.e. in US a new sheet will be named "Sheet1" in Dutch it is
> named "Blad1".
> Can i directly add a new sheet with a name?
>
> thank you,
>
> Just

Worksheets.Add(after:=Worksheets(Worksheets.Count) ).Name = "mySheetname"


--
---
HTH

Bob


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



"Just Merks" <jvw.merks@hccnet.nl> wrote in message
news:483bbda5$0$3243$e4fe514c@dreader20.news.xs4al l.nl...
> Hello,
>
> I created a Macro which will be used by different users. In this macro I
> do add a new sheet which I want to rename.
> However based on the regional settings the new sheet will receive a
> different name. I.e. in US a new sheet will be named "Sheet1" in Dutch it
> is named "Blad1".
> Can i directly add a new sheet with a name?
>
> thank you,
>
> Just
>
>
>