inserting worksheet and name

[Bill Starr]

I saw some code somewhere, but I can't find it anymore.

I need to insert a worksheet and then name this new
sheet 'vacation'. The workbook may already have a sheet
called 'sheet1' or 'sheet2'.

thanks.
Bill

 

[Dave Peterson]

worksheets.add
on error resume next
activesheet.name = "vacation"
if err.number <> 0 then
msgbox "couldn't rename"
err.clear
end if