Repository files navigation

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 visithttp://www.excel-vba-easy.com/vba-programming-function-sub.html orhttp://www.excelfunctions.net/VBA-Functions-And-Subroutines.html.

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

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

WherelastRow(ws) returns thelast row number of worksheetws, and3 is Column C (the third column in a worksheet).

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

This software is available under the MIT license.