How do we create a worksheet in new workbook
Dim wb As Workbook
Set wb = Workbooks.Add(xlWBATWorksheet)
wb.Worksheets(1).Name = "Pay-Per-Click"
wb.Sheets.Add (xlWorksheet)
wb.Worksheets(2).Name = "Categories"
This returns an error back Application Defined - Object Defined error
Thanks,
Sridhar
Dim wb As Workbook
Set wb = Workbooks.Add(xlWBATWorksheet)
wb.Worksheets(1).Name = "Pay-Per-Click"
wb.Sheets.Add (xlWorksheet)
wb.Worksheets(2).Name = "Categories"
This returns an error back Application Defined - Object Defined error
Thanks,
Sridhar