Search results 623

Sorted from new to old.

Match6_Until

Searches for six values in six columns and return the row number if all found, ...

Thu 1PM

FilesIn2 - sorted files

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

Nov25

VBInstr_Any

Search for string inside another, with ability to have multiple strings to ...

Nov15

ANmaSum_4IFs

Applies SumIFs for 4 columns, same sheet, same workbook Another function to do ...

Nov13

ConditionalFormatting_ColorARow

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

Nov10

RegExPatternMatch

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

Nov10

Showing 4k (and more) images in BS5 modal

Allow users to browse and scroll through tons of images to select one (tried on ...

Nov7

Sheet_RowID_Generate + _LastUsed

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

Nov3

HTMLTable_NoOfColumns

Gets no of columns in an HTML table. It actually gets the maximum number of ...

Oct26

MaxOfArray

Gets the maximum number from an array. Like

Oct24

CountColumnCells_Unique

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

Oct6

Walking Columns (Scrollable Columns-Chart)

Allow users to scroll through columns in column-chart. Used chart.js, this is ...

Sep30

Font-Based progress bar

Show progress bar using fonts only. Neat trick to use inside HTML or word ...

Sep29

ANmAddressRefStyle

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

Sep23

ANmaFiles2List

Generating list of files in a folder. One file to do that. I know this has ...

Sep21

RegSave, RegRead, RegDelete

Windows Registry read, save and delete branch node or key. Three functions use ...

Sep15

1 2 ...38 39