Excel-VBA-Data-Functions

KO | EN

gitlite — search

#typescript #ai-agents #ai #dsh-plugin #deepseek-harness #open-source #cli #claude-code #codex #developer-tools #react #windows

Excel-VBA-Data-Functions

★ 75 Open GitHub ↗

Excel VBA Functions Package for Business Data Analysts. VBA has a reputation among some for being a "step child" programming language, however it enables practitioners to deliver real value to their local business units quickly.

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

![Excel Logo Banner](https://www.versionmuseum.com/images/applications/microsoft-excel/microsoft-excel%5E2016%5Eexcel-logo-new.png)

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
```vba
Set ws = workbooks("currentOpenWorkbook.xlsx").worksheets("Sheet1")
ws.cells(lastRow(ws),3).select
```
Where `lastRow(ws)` returns the **last row number** of worksheet **ws**, and **`3`** is Column C (the third column in a worksheet).

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

# License #

This software is available under the MIT license.

Excel-VBA-Data-Functions

Explore Similar Repositories

Was this content helpful?

Recent Feedback

Download README