VBA-Excel 342

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

Sorted from new to old.

ANmaNotMatch

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

Apr19

FirstDuplicatedItem

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

Apr18

ANmaRow_Duplicate1

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

Apr17

MatchIf4Up

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

Apr12

NumberBeforeString

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

Apr10

String_Fx

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

Apr10

DateAdd_Networkdays

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

Apr6

ListBox_Read and ListBox_Save

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

Mar11

CutString_ANmaRules

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

Feb26

HTMLTableRow_LastRowWithData

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

Feb19

ToggleCells

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

Feb2

Toggle5Values

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

Feb2

TrimLines

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

Jan31

HTMLTable_FindTable

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

Jan12

ANStrFind_AndOrRemove

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

Jan12

ANmaSum_5IFs

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

Jan8

1 2 ...21 22