Search results 74

Sorted from new to old.

MatchIf4Up

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

Sat 11AM

VBInstr_Rev_Any

Finds first match of string inside another in reverse order. From right to left ...

Fri 4AM

ListBox_Read and ListBox_Save

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

Mar11

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

ANmaSearch_AllWords_FromANStr

Checks if string has all words from ANStr inside Retuns 0 if not found or ...

Jan8

Match6_Until

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

2024Nov28

CutString96_NumberBefore and After

Cuts the number found before our search word by going back certain number of ...

2024Nov24

Match4_Until

Search 4 columns with a stop. Tell the function to stop searching after certain ...

2024Nov22

VBInstr_Any

Search for string inside another, with ability to have multiple strings to ...

2024Nov15

ANmaSum_4IFs

Applies SumIFs for 4 columns, same sheet, same workbook Another function to do ...

2024Nov13

Match5_5thNot0 and Match6_6thNot0

Searches for 4 cells in 4 columns then checks for 5th column to not equal zero ...

2024Nov13

ConditionalFormatting_ColorARow

Adds conditional formatting to color a row in table based on output of formula ...

2024Nov10

RegExPatternMatch

Checks string against pattern using RegEx (VBScript.RegExp). The pattern ...

2024Nov10

Match3_3rdNot0

Searches for two cells in two columns then checks for 3rd column if not equal ...

2024Nov2

Match4_4thNot0

Searches for three cells in three columns then checks for 4th column if not ...

2024Nov1

1 2 3 4 5