Search results 62

Sorted from new to old.

ANmaFormatLastRow

Format last row found/added in Excel range to certain color. ColorText is the ...

Mar26

Create Tree from 3 columns (Sheet2Tree)

Converts 3 columns in sheet into 3-generation tree using TreeView from Mscomctl. ...

2025Aug7

CutString_JsonKeyValue

Reads value from json string for certain key. Using RegEx Regular Expression. ...

2025Jul27

Calculation_StaleValues

Show Stale function formats or hide Excel recently started to show cells with ...

2025Jun30

ANmaRemoveMultiSpace

Removes multiple spaces from within string, those are up to 16 spaces that ...

2025May16

MatchIf8Up

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

2025May7

VBInstr_SpaceFriends_BetweenHTMLTags

Searches for string inside string with multiple possibilities, returns ...

2025Mar13

FilesIn2 - sorted files

List of files, sorted by name, size or modified date ascending or descending. ...

2024Nov25

RegExPatternMatch

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

2024Nov10

Sheet_RowID_Generate + _LastUsed

Generate random unique ID in a column as IDyyyymmRRRR And the second function ...

2024Nov3

Choose2

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

2024Aug20

HTMLTable_FullRow_NonBlanks

Returns all numeric values in row separated by Sepa Only cells that are not ...

2024Aug7

Center Userform

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

2024Jul23

ANmAdd_ThenSort_2Columns

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

2024Jun1

OrderedList in Arabic Alphabet

Using Arabic in ordered list in HTML, as Abjad or Alphabet. Was playing with ...

2024Feb25

VBInstrRev

Similar to VBInstr, but this one does it in reverse, which is instrrev() ...

2024Jan24

1 2 3 4