VBA-Excel 382

Visual basic for applications that works only in Microsoft Excel, aka macros
Sorted from new to old.
Card image
Convert_Dash_to_Zero

Convert cells with dashes to zeros. Quick code needed to reset sheet copied ...

Card image
Range2Block

Concatenate all rows found in a range starting A1Cell for Columns_To columns ...

Card image
Range_Add_or_Subtract

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

Card image
NavigatePost

Reads content of webpage with optional post data two main differences from

Card image
ANmaVLookup

Finds first occurrence of item in column, then returns value from same row as ...

Card image
Listbox 1st item [Any]

Allow user to select [Any] as first item in list that will deselect all other ...

Card image
ANStr2Range

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

Card image
Popup button

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

Card image
Dropdown button commands

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

Card image
RunOnTime

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

Card image
ANmaRemoveDuplicates

Removes duplication in table in 1 or more columns using Excel ...

Card image
ANmAdvancedFilter

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

Card image
Cell_Add_or_Subtract

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

Card image
LstCustomSelection_Refresh

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

Card image
ANmaBatchCreate + ANmaBatchRun

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

Card image
HyperlinkFunction

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