VBA-Excel 339

Visual basic for applications that works only in Microsoft Excel, aka macros
  2. Languages
  3. VBA-Excel
Sorted from new to old.
Card image
MatchIf4Up

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

Sat 11AM
Card image
NumberBeforeString

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

Thu 3PM
Card image
String_Fx

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

Thu 3PM
Card image
DateAdd_Networkdays

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

Apr6
Card image
ListBox_Read and ListBox_Save

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

Mar11
Card image
CutString_ANmaRules

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

Feb26
Card image
HTMLTableRow_LastRowWithData

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

Feb19
Card image
ToggleCells

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

Feb2
Card image
Toggle5Values

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

Feb2
Card image
TrimLines

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

Jan31
Card image
HTMLTable_FindTable

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

Jan12
Card image
ANStrFind_AndOrRemove

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

Jan12
Card image
ANmaSum_5IFs

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

Jan8
Card image
ANmaRemoveDuplicates2

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

2024Dec4
Card image
ANmaRemoveDuplicates4

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

2024Dec4
Card image
VBInstr_Occurance

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

2024Dec1
12...2122