Matching by two values at the same time in two columns Just like Match the ...
Horizontal match for a value in a row Horizontal MatchIf, returns column ...
The best Match I created, return 0 if not found, kind of CountIF+Match ...
Reversing a file This tip demonstrates how to reverse a whole file. This ...
Opens Workbook without running AutoMacros and without letting the user know ...
Delete all shapes in a sheet
Finds a name in a workbook, returns true or false
SQL seams to have issues when we try to modify a table and preserving data, I ...
Finds a sheet in a workbook, if no workbook name passed, it will use ...
Using same code in CutString3, this will search for matching items. Searches ...
Counts how many cells in a column in any sheet, any workbook using COUNTIF ...
Opens webpage from within Excel, using default browser
Show Shareware softwareHow to use it:Frm4.ShowMeOrFrm4. ...
This is the final version of my set of Setting functions SettingRead, ...
Enables users to list and delete files
This is an application that creates a form in HTML depending on user specs
50 chars max.