inserting worksheet and name

  • Thread starter Thread starter Bill Starr
  • Start date Start date
B

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
 
worksheets.add
on error resume next
activesheet.name = "vacation"
if err.number <> 0 then
msgbox "couldn't rename"
err.clear
end if
 
Back
Top