liujiancong911/excel-vba-data-functions

Excel VBA Functions Package for Business Data Analysts

Excel VBA Functions Package for Business Data Analysts

Created to facilitate data processing and analysis at the business operations level. Common functions used for Excel-based projects / reports / apps requiring extensive data manipulation.

Drag and drop the .bas file as a module in the VBA editor.

Requires a basic understanding of how to use functions within VBA. For an overview, please visit http://www.excel-vba-easy.com/vba-programming-function-sub.html or http://www.excelfunctions.net/VBA-Functions-And-Subroutines.html.

Note that most functions included in this package require a worksheet object as the first argument.

Example using the lastRow function:

' If the last row of data is located on row 15, this routine will select cells A1:C15
Set ws = workbooks("currentOpenWorkbook.xlsx").worksheets("Sheet1")
ws.cells(lastRow(ws),3).select

Please feel free to contact me for any help/clarification.