VBA-Excel 329

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

Sorted from new to old.

DateDiff_Networkdays

Calculates no of workdays between two dates. Option to use international ...

2024Jul25

Center Userform

Looks like forcing a Userform to be in center of an application is not as easy ...

2024Jul23

RemoveSignWord

Removes the WordTemplate [Sign-Head-????] from FromStr and returns whatever ...

2024Jul15

ReturnLongestString_Of2

Returns the string that is longer, comparing what is before StrSepa versus ...

2024Jul2

CountRowCells

Counts how many cells with data in a row, starting from certain column until ...

2024Jun22

JSON_To_Table

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

2024Jun6

Min_No0s

Getting the minimum number from an array excluding zeros.

2024Jun5

ANmAdd_ThenSort_2Columns

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

2024Jun1

MatchIf6Up

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

2024May31

MatchIf6

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

2024May31

MatchIf5Up

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

2024May27

ANmaSearch_ApostropheFriends

Searches for string inside string with apostrophe variations conversion

2024May27

ANmaHTMLTables_Combine2

Combine strings of two HTML tables into string of one table. Edit 2024-10-31: ...

2024May16

MatchIF5

Searching for rows having 5 values in 5 columns Like

2024May6

CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

2024May1

MatchIf2Up

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

2024Apr29

1 2 3 ...20 21