ANStr2Range

Converts a string of items into range, with custom separator. Opposite of

SwapNumbers

Swap two numbers variables without using third variable A trick worth saving ...

Popup button

List of commands in popup menu. Uses listbox, command button and toggle ...

Drodown-popup-Button.zip

Dropdown button commands

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

DropdownButton.zip

RunOnTime

Runs a certain macro on certain time. This is not a scheduler, but just simple ...

ANmaRemoveDuplicates

Removes duplication in table in 1 or more columns. Will work in sheet, ...

ANmAdvancedFilter

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

Cell_Add_or_Subtract

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

LstCustomSelection_Refresh

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

ANmaBatchCreate + ANmaBatchRun

Creates batch file with certain content, and another function to actually ...

HyperlinkFunction

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

AddDatabar_ConditionalFormatting

Adds databars conditional formatting to range of cells. Passing column, start ...