Macro to add a named sheet

  • Thread starter Thread starter Just Merks
  • Start date Start date
J

Just Merks

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
 
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)
 
Back
Top