VBA-Excel 370

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

Sorted from new to old.

NumberBeforeString

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

2025Apr10

String_Fx

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

2025Apr10

DateAdd_Networkdays

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

2025Apr6

ListBox_Read and ListBox_Save

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

2025Mar11

CutString_ANmaRules

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

2025Feb26

HTMLTableRow_LastRowWithData

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

2025Feb19

ToggleCells

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

2025Feb2

Toggle5Values

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

2025Feb2

TrimLines

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

2025Jan31

HTMLTable_FindTable

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

2025Jan12

ANStrFind_AndOrRemove

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

2025Jan12

ANmaSum_5IFs

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

2025Jan8

ANmaRemoveDuplicates2

Remove duplicated rows based on 2 columns in a table of any number of columns. ...

2024Dec4

ANmaRemoveDuplicates4

Removes duplicated rows in a table based on 4 duplicated columns. Table can be ...

2024Dec4

VBInstr_Occurance

Returns location of text inside another with jump ability for any certain ...

2024Dec1

Match6_Until

Searches for six values in six columns and return the row number if all found, ...

2024Nov28

1 2 3 ...23 24