Search results 124

  2. Search results
  3. like
Sorted from new to old.
Card image
RegExPatternMatch

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

2024Nov10
Card image
ANmAddress_Value

Returns the value of a cell address in another sheet. Todo: Allow to reference ...

2024Oct31
Card image
MaxOfArray

Gets the maximum number from an array. Like

2024Oct24
Card image
CountColumnCells_Unique

COunts unique cells found in a column. Passing sheetname, workbook name and ...

2024Oct6
Card image
RoundUp2

Rounds a number to nearest identifier up. Like 105 up to nearest 20 ...

2024Oct1
Card image
CutString12

Cuts string between two numbers that found inside string. Like extract the ...

2024Aug22
Card image
CutString96_NumberX

Extract a full number from string block having 1 or more full numbers. Like ...

2024Aug2
Card image
ANmaSearch_OrFriends

Search for one of items in SearchFor_ListOfFriends inside SearchIn and return ...

2024Jul30
Card image
Center Userform

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

2024Jul23
Card image
ANmaReplace_Occurrence

Replaces certain occurrence of a string with another inside a string. Like ...

2024Jul13
Card image
Q_NoOfdays

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

2024Jun9
Card image
ANmAdd_ThenSort_2Columns

Adds values of 2 cells into 2 columns (usually below them). I used these small ...

2024Jun1
Card image
MatchIf5Up

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

2024May27
Card image
MatchIF5

Searching for rows having 5 values in 5 columns Like

2024May6
Card image
CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

2024May1
Card image
ContainerHTMLTag_ReturnBlock

Returns the full string starting from open tag of container where LocationIndex ...

2024Apr3
12...78