VBA-Excel 292 Visual basic for applications that works only in Microsoft Excel, aka macros

  2. Languages
  3. VBA-Excel
Card image cap
JSON_To_Table

An attempt to read json into table. This one is a work in progress, tested and ...

Jun6
Card image cap
Min_No0s

Getting the minimum number from an array excluding zeros.

Jun5
Card image cap
ANmAdd_ThenSort_2Columns

Adds values of 2 cells into 2 columns (usually below them). I used these small ...

Jun1
Card image cap
MatchIf6Up

Searches for 6 values in 6 columns and return the row number found in. ...

May31
Card image cap
MatchIf6

Searching for row have 6 matches found in 6 different columns, because we had 5, ...

May31
Card image cap
MatchIf5Up

Searches for five cells in five columns and return the row number if all found ...

May27
Card image cap
ANmaSearch_ApostropheFriends

Searches for string inside string with apostrophe variations conversion

May27
Card image cap
ANmaHTMLTables_Combine2

Combine strings of two HTML tables into string of one table.

May16
Card image cap
MatchIF5

Searching for rows having 5 values in 5 columns Like

May6
Card image cap
CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

May1
Card image cap
MatchIf2Up

Search for 2 items in 2 columns starting from last row upword (Starting with ...

Apr29
Card image cap
SettingSave + SettingRead for NumberFormat

Reads or applies certain NumberFormat to cell in settings. Same patterns as ...

Apr19