What Is Worksheet And Workbook. Worksheet adalah bagian dari workbook yang merupakan area kerja tempat menginput atau mengedit suatu data, tabel, atau chart di dalam excel. A workbook is a file that stores the entered related data;
You can create a new workbook from a blank workbook or a template. Learn more about the workbook and worksheet object in excel vba. Worksheet terdiri atas baris (row) dan kolom (column).
Worksheets can be added, deleted or renamed within the workbook.
Sub sb_copy_save_worksheet_as_workbook() dim wb as workbook set wb = workbooks.add thisworkbook.sheets(sheet1).copy before:=wb.sheets(1) wb.saveas c:\temp\test1.xlsx end sub. A worksheet is a page of the workbook on which all the data is held. Sub sb_copy_save_worksheet_as_workbook() dim wb as workbook set wb = workbooks.add thisworkbook.sheets(sheet1).copy before:=wb.sheets(1) wb.saveas c:\temp\test1.xlsx end sub. For best results with printing your worksheet, use the print command in excel for the web, not your browser’s print command.