Search results 59
Sorted from new to old.

ANmaRemoveDuplicates2
Remove duplicated rows based on 2 columns in a table of any number of columns. ...

ConditionalFormatting_ColorARow
Adds conditional formatting to color a row in table based on output of formula ...

Progress in two nested loops
Formula to show progress to end user from inside two loops. More like an ...

Range_Add_or_Subtract
Adds an amount (or subtract) from a range of cells in one click Similar to

Dropdown button commands
A drop-down of multiple commands in pure VBA. Needed this in a large Excel-VBA ...

Cell_Add_or_Subtract
Adds amount to active cell, or subtract Applies to selected cell in current ...

HyperlinkFunction
Returns the formula for a hyperlink [=Hyperlink(...) ] to be inserted in a cell. ...

ANmaSQL_UpdateDateStatement
Creates "Update Table " SQL statements to be executed inside SQL to modify ...

ANmaSQL_InsertStatement
Creates SQL INSERT statements from a table in Excel. Used to be executed to ...