title: Change the name of added worksheet
body: <pre><code>objWriteWorkbook.sheets.add ,objWriteWorkbook.sheets(objWriteWorkbook.sheets.count)
  Set NewWorksheetObject = objWriteWorkbook.Worksheets(num)
  objWriteWorkbook.Sheets(num).Name = sheetName 
  </code></pre>
  
  <p>I wanted to change the name of added worksheet.
  Adding of sheet and object creation for that sheet is working fine but when I try to change the name of the sheet I am getting an error <strong>"Unknown runtime error"</strong></p>
  
  <p>Can any one help how can change the name of added sheet.</p>