BoldCodes

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

Returns the date of 1st day or last last day in a Quarter Mar 31st, Jun 30th, ...

Fri 5PM

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

Thu 5PM

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

Tue 4AM

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

Jul15

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

Jul2

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

Jun22

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

Jun6

Getting the minimum number from an array excluding zeros.

Jun5

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

Jun1

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

May31

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

May31

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

May27