Search results 203

  2. Search results
  3. Sheet
Sorted from new to old.
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
ANmAddressRefStyle

Returns type of the cell address, A1 or R1C1 If multiple cells passed, the ...

2024Sep23
Card image
ANmaCellChar_Superscript_Subscript

Sets certain character inside a cell as superscript or subscript Edit ...

2024Aug11
Card image
ANmAdd_ThenSort_2Columns

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

2024Jun1
Card image
MatchIf6

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

2024May31
Card image
MatchIf2Up

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

2024Apr29
Card image
SettingSave + SettingRead for NumberFormat

Reads or applies certain NumberFormat to cell in settings. Same patterns as ...

2024Apr19
Card image
ANmaCellFormat

Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...

2024Apr18
Card image
SortArea4

Sort range of cells by up to 4 columns. Can use any of these columns, not ...

2024Apr15
Card image
VBInstr_Numeric

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

2024Feb25
Card image
SwitchTextinCells

Switch text inside cells with another text. This was needed to correct an bug ...

2024Feb23
Card image
VLookup_HTML

Does a search in 1st column (< td tag) in an HTML table (< table tag), and ...

2024Jan26
Card image
RangeValues

Returns values of all cells in range into 1 string Only non-blank values ...

2024Jan25
Card image
PivotTable_ShowHideItems

Show or hide item (or items) in PivotTable for a certain field. Passing ...

2024Jan23
Card image
PivotTable_ShowHideBlankItems

Shows or hides an item or items in a PivotTable filter field. Passing ...

2024Jan22
123...1213