What happened when you tried it?

(It worked for me.)

Ant wrote:

I want to insert a new sheet and name it "ABC":

Sheets.Add
Sheets("Sheet1").Name = "ABC"

This is fine for the first time as it inserts a new sheet called "Sheet1".
However the next time I do it the newly inserted sheet is called "Sheet2",
but the code is still looking for a "Sheet1".

Can I do something simple like:

Sheets.Add.Name = "ABC"

Thanks in advance.

--

Dave Peterson