

Worksheets(i).Activate makes i-th worksheet active (bring to foreground).Worksheets(i).Cells.Clear to wipe out all content in a worksheet.Worksheets(i).Cells.ClearComments to clear all comments in all cells in a worksheet.Worksheets(i).=xlNone to clear background color in all cells in a worksheet.IsEmpty(cell) checks whether cell is empty.MsgBox(string) for displaying a short text in a message box.


Worksheets(i) references the i-th sheet, usually they are called Sheet1, Sheet2, Sheet3.Below are some simple basic concepts to access and change the spreadsheet data. 27th October 2013 Programming in Excel VBA Compared To LibreOffice (OpenOffice) Calc
