Search results 71

Sorted from new to old.
Card image
Match6_Until

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

Card image
Match4_Until

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

Card image
VBInstr_Any

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

Card image
RegExPatternMatch

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

Card image
Match3_3rdNot0

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

Card image
Match4_4thNot0

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

Card image
Font-Based progress bar

Show progress bar using fonts only. Neat trick to use inside HTML or word ...

Card image
ANStr_Add10IfNotBlank_NorNA

Concatenate string into one, if not blank and not N/A It looked stupid for me ...

Card image
Center Userform

Looks like forcing a Userform to be in center of an application is not as easy ...

Card image
Q_NoOfdays

Calculates number of days for certain quarter, starting from given quarter with ...

Card image
MatchIf6Up

Searches for 6 values in 6 columns and return the row number found in. ...

Card image
MatchIf6

Searching for row have 6 matches found in 6 different columns, because we had 5, ...

Card image
MatchIf5Up

Searches for five cells in five columns and return the row number if all found ...

Card image
MatchIf2Up

Search for 2 items in 2 columns starting from last row upword (Starting with ...

Card image
MatchIfUp or MatchIfRev

Searching for an item in a column from bottom to top. Will search for item in ...

Card image
Just learnt that now

Looks like we cannot have filename (having no extension) and folder in same ...