VBA-Excel 281 Visual basic for applications that works only in Microsoft Excel, aka macros
Part of cells in Excel
How to modify part of text inside an Excel cell using VBA. Something in my ...
UI_2ValidationsUpdate
Apply validation on two cells, when a 3rd cell is changed When modifying a ...
CreateList_Matching
Creates list of items found in rows, where these rows match a value in another ...
Column2AnString_Unique
Creates list of unique items found in a column, returns string with items ...
Delete_Unwanted_Rows
Delete rows in a different way I used to delete rows by looping through those ...
DB_Connect_Install
Connects to SQL DB using ADODB, if driver not installed, it will attempt to ...
DB_Connect_Install.zip