Search results 69

Sorted from new to old.

VBInstr_Any

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

Fri 5AM

RegExPatternMatch

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

Nov10

Match3_3rdNot0

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

Nov2

Match4_4thNot0

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

Nov1

Font-Based progress bar

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

Sep29

ANStr_Add10IfNotBlank_NorNA

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

Jul24

Center Userform

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

Jul23

Q_NoOfdays

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

Jun9

MatchIf6Up

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

May31

MatchIf6

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

May31

MatchIf5Up

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

May27

MatchIf2Up

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

Apr29

MatchIfUp or MatchIfRev

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

Apr8

Just learnt that now

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

Mar5

VBInstr_Numeric

Finds location of 1st numeric character inside string starting from a certain ...

Feb25

EdgarCIK

Search for company long name in Edgar and returns its CIK Using SEC.gov site ...

Feb25

1 2 3 4 5