ANmAdvancedFilter

Filter table inside Excel the fast way (using advanced filter) into another ...

LstCustomSelection_Refresh

Read list of items from Settings sheet, then Sort, then save, before reading ...

SettingNameAlreadyFound

Searches for a setting value in set of Settings, in Excel spreadsheet using ...

Old cell value

Nice solution to read value in cell AFTER changed. Needed to have that feature ...

NMRRank_v2021

Ranks a number among set of numbers. This is part of huge tool, we needed to ...

Open Window

Open another window with java script (_blank) Setting up width, height, ...

ToolPath

Returns the path of ThisWorkbook considering OneDrive Personal or Business ...

Resize_Me2 + Resize_Me3

Resizes Excel window to certain small size and location (hard-coded) and hide ...

ExitTool and DoNothing

My way of Exiting tool in case or error, also another sub that basically does ...

UI_2ValidationsUpdate

Apply validation on two cells, when a 3rd cell is changed When modifying a ...

DB_Connect_Install

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

DB_Connect_Install.zip

Online Wordpress password hash generator

An online tool to generate password hash for wordpress, tried it just today ...