Adding new sheet problem-Macro

[pikapika13]

I'm very new to this. I'm trying to open a new worksheet and call it a
name.
However, I never know what sheet name excel is going to give me:
sometimes "Sheet1" or "Sheet10". It depends on how many times I run
the macro.
Is there a way to convert this:
' Workbooks.Add
Sheets("Sheet1").Name = "M1"

to something more friendly?

 

[JE McGimpsey]

one way:

With Worksheets.Add
On Error Resume Next 'in case M1 exists
.Name = "M1"
On Error GoTo 0
End With

 

[Martin]

When the sheet's first made, it's the active sheet so I'd change the second
line to:
ActiveSheet.Name = "M1"