Another method:

Sheets.Add.Name = "TEST"

HTH

"Natalie" wrote:

I would like to record a macro that allows me to insert a new sheet. However,
it inserts a DIFFERENT sheet no everytime. How should I write a sub that will
technically allow me to insert a new sheet rather than a predefined sheet
name like sheet 4 or sheet 5? thanks