digifere.blogg.se - Openoffice base vba

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.Cells(i,j).Interior.Color sets the background color of the cell.Cells(i,j).AddComment("my comment") adds a comment to the cell.Cells(i,j).Value is the content of the cell.

Cells(i,j) references i-th row, j-th column, e.g., Cells(2,3) is C2.

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