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

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



Bill Starr wrote:

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