VBA-Excel 323
Visual basic for applications that works only in Microsoft Excel, aka macros
Sorted from new to old.
CutString96_NumberBefore and After
Cuts the number found before our search word by going back certain number of ...
Match5_5thNot0 and Match6_6thNot0
Searches for 4 cells in 4 columns then checks for 5th column to not equal zero ...
ConditionalFormatting_ColorARow
Adds conditional formatting to color a row in table based on output of formula ...
ANmAddress_Dimensions
Detects how many dimensions an address has, This is what I call it dimensions ...
Sheet_RowID_Generate + _LastUsed
Generate random unique ID in a column as IDyyyymmRRRR And the second function ...
HTMLTable_NoOfColumns
Gets no of columns in an HTML table. It actually gets the maximum number of ...