Search results 331

  2. Search results
  3. option
Sorted from new to old.
Card image
ConditionalFormatting_ColorARow

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

2024Nov10
Card image
ConditionalFormatting_Clear

Clears all conditional formatting in a range in a sheet in a workbook.

2024Nov10
Card image
RegExPatternMatch

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

2024Nov10
Card image
ANmAddress_Dimensions

Detects how many dimensions an address has, This is what I call it dimensions ...

2024Nov8
Card image
SettingRead_Bulk

Reads list of passed SettingNames with defined separator from Settings and ...

2024Nov3
Card image
Match3_3rdNot0

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

2024Nov2
Card image
Match4_4thNot0

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

2024Nov1
Card image
CleanArray_2Dim

Cleans an array of 2 dimensions from blank in 1st column. Similar to

2024Oct24
Card image
CountColumnCells_Unique

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

2024Oct6
Card image
Choose20

Chooses from 20 options based on the passed ID, can have any of these passed. ...

2024Sep5
Card image
Choose10

Choosing a return value based on an ID. Since we have Choose2, Choose3 and ...

2024Sep3
Card image
CutString12

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

2024Aug22
Card image
IsNumericChar

Checks if character is number or no. Returns True or False Number includes the ...

2024Aug21
Card image
Choose2

Returns a value based on an ID. If ID is 1, return 1st value, If ID is 2, ...

2024Aug20
Card image
ANmaRead_1stFile

Returns information about first file name found after sorting matching files in ...

2024Aug11
Card image
ANmaCellChar_Superscript_Subscript

Sets certain character inside a cell as superscript or subscript

2024Aug11
123...2021