SettingNameAlreadyFound

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

FoundinList

Finds a matching item of a number in list of numbers. Returns 1 if found, 0 if ...

Protecting VBA code

Steps to protect VBA project in Excel, posted here for reference mainly. An ...

Export2CSV

Exports a sheet into CSV file Dynamically finds number of rows/columns and ...

COUNTIFS as Rank

Simplest way to rank among peers. used COUNTIFS in case we need to add more ...

InStr and InStrRev

How to use InStr and InStrRev VB functions It is silly, I know, but I keep ...

Subtotal_Indirects

Finds the SUM, COUNT, COUNTA, etc for a range of cells referencing using ...

CutString8

Cuts a string from certain character to certain character with option of either ...

Regular expressions (Notepad++)

How to do regular expressions in Notepad ++ search and/or replace Helpful when ...

RBU - Simple Registry Backup batch

RBU simply means "Registry Back Up" and is a tiny BAT (batch) file that will ...

RegBackup.zip

Delete_Unwanted_Rows

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

NameNum

Finding the number of a name, used in a numerology program. Finds the number ...