Search results 62

Sorted from new to old.
Card image
ANmaFormatLastRow

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

Card image
Create Tree from 3 columns (Sheet2Tree)

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

Card image
CutString_JsonKeyValue

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

Card image
Calculation_StaleValues

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

Card image
ANmaRemoveMultiSpace

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

Card image
MatchIf8Up

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

Card image
VBInstr_SpaceFriends_BetweenHTMLTags

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

Card image
FilesIn2 - sorted files

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

Card image
RegExPatternMatch

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

Card image
Sheet_RowID_Generate + _LastUsed

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

Card image
Choose2

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

Card image
HTMLTable_FullRow_NonBlanks

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

Card image
Center Userform

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

Card image
ANmAdd_ThenSort_2Columns

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

Card image
OrderedList in Arabic Alphabet

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

Card image
VBInstrRev

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