VBA-Excel 302

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

Sorted from new to old.

ANmaCellChar_Superscript_Subscript

Sets certain character inside a cell as superscript or subscript

Aug11

HTMLTable_FullRow

Returns full row from RowID ... the full area between < tr ...> and < /tr> from ...

Aug4

ANstr_Column

Reads and concatenate the full HTML or non-HTML of column (ColumnID) from HTML ...

Jul29

Unblock blocked macros.

Unblock macros in file copied or downloaded from another machine. Excel keeps ...

Jul27

Quarter1stLastDate_FromQuarterText

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

Jul26

DateDiff_Networkdays

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

Jul25

Center Userform

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

Jul23

RemoveSignWord

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

Jul15

ReturnLongestString_Of2

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

Jul2

CountRowCells

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

Jun22

JSON_To_Table

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

Jun6

Min_No0s

Getting the minimum number from an array excluding zeros.

Jun5

ANmAdd_ThenSort_2Columns

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

Jun1

MatchIf6Up

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

May31

MatchIf6

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

May31

MatchIf5Up

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

May27

1 2 ...18 19