Excel functions

Excel functions

In this section you can find VBA functions and subroutines to operate on Excel components, like worksheets, workbooks or cell ranges.

The functions are listed below:

Function to check if the given Excel worksheet is valid and can be referred (`isSheetValid`)

Function to check if the given Excel workbook is valid and can be referred (`isBookValid`)

Function to check if the given Excel range is valid and can be referred (`isRangeValid`)

Function to check if two variables of Worksheet type refer to the same Excel worksheet (`isTheSameSheet`)

Function to check if a given String can be used as a worksheet name (`legalSheetName`)

Function to check if a given name would be unique in the specified Excel worksheet (`uniqueSheetName`)

Function to return the index number of the first non-empty column in a given Excel worksheet (`firstNonEmptyColumn`)

Function to return the index number of the last non-empty column in a given Excel worksheet (`lastNonEmptyColumn`)

Function to return the index number of the first non-empty row in a given Excel worksheet (`firstNonEmptyRow`)

Function to return the index number of the last non-empty row in a given Excel worksheet (`lastNonEmptyRow`)

Function to return the index number of the next visible row in a given Excel worksheet (`nextVisibleRow`)

Function to return the index number of the next visible column in a given Excel worksheet (`nextVisibleColumn`)

Function to create a new Excel workbook with the specific number of worksheets (`newWorkbook`)

Function to find header row in the given Excel worksheet (`findHeaderRow`)

Function to return the specified column from the given 2D array as a 1D array (`getArrayColumn`)

Function to open the specified Excel file (`openWorkbook`)

Function to check if the given Excel file is open (`isFileOpen`)