CountDuplicates

Counts how many duplicates found in a range of Excel cells. Basically how many ...

Part of cells in Excel

How to modify part of text inside an Excel cell using VBA. Something in my ...

ListBox_Excel_Sort

Sort items in Fm20 Listbox using Excel spreadsheet Sort function. Can decide ...

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 ...

FolderSize_Swift

Gets total of folder size in bytes. With some tweaks, you can modify it to use ...

Delete_Unwanted_Rows

Delete rows in a different way I used to delete rows by looping through those ...

DeleteOtherSheets

Deletes all sheets in a workbook keeping only one

IsThere1_SPWB

Checks if a workbook is found in a SharePoint location or not, giving a full ...

NextID_Reset

Checks if ID has been reset in SQL database table If yes, it will reset it and ...

DB_Connect_Install

Connects to SQL DB using ADODB, if driver not installed, it will attempt to ...

DB_Connect_Install.zip