Create Workbook - Single sheet
In some case if you wnat to copy some cell values to a new workbook, in that case you dont want to create a workbook with three sheets(by default), create a workbook with single sheet using the code
         ------------ ' Workbooks.Add(xlWBATWorksheet) '---------------
this code create a workbook with single sheet.
 
 

 
 
 
 


 
No comments:
Post a Comment