VBA-Excel 342

Visual basic for applications that works only in Microsoft Excel, aka macros
Sorted from new to old.
Card image
ANmaNotMatch

Finds first item from RngAddr that is not listed in InRngAddr Returns the item ...

Card image
FirstDuplicatedItem

Returns the value of first duplicated item found in a range. This is to ...

Card image
ANmaRow_Duplicate1

Duplicate 1 row into row below with insert using fill down or copy-paste No ...

Card image
MatchIf4Up

Returns row of matching 4 values in 4 columns searching from bottom to top. ...

Card image
NumberBeforeString

Returns number if found before certain word in larger string. This can be used ...

Card image
String_Fx

Generate repeated text, like String() the function but with ability to repeat ...

Card image
DateAdd_Networkdays

Adds workdays to a date using DateAdd It keeps adding days and checks how many ...

Card image
ListBox_Read and ListBox_Save

Reads or saves to a certain column in multi-column listbox in VBA Userform Can ...

Card image
CutString_ANmaRules

Extract certain text from another text based on Rules defined, like extracting ...

Card image
HTMLTableRow_LastRowWithData

Retunes the row from bottom that has data (not blank or hidden)

Card image
ToggleCells

Toggle a value through list of cells in a range Pass current value and range ...

Card image
Toggle5Values

Toggles among up to 5 values. Pass the current values, then up to 5 values (in ...

Card image
TrimLines

Remove all line breaks from text from a text. Not like

Card image
HTMLTable_FindTable

Reads < table .... < /table> found after index Have ability to opnly bring the ...

Card image
ANStrFind_AndOrRemove

Checks (and/or removes) if an item was found in list of items and return 1 if ...

Card image
ANmaSum_5IFs

Returns Sum conditionally of 5 columns (SumIFS), in a sheet, certain workbook ...