Search results 61

Sorted from new to old.

FormatNumbers_InsideText

Formats all numbers found inside text to certain format. Excluding numbers ...

Mar9

FilesIn_4Array

Returns list of file names along with path, date modified and size in array of ...

2025May25

MatchIf8

Searches for 8 cells in 8 columns and returns the row number if all found. Has ...

2025May10

VBInstr_Any

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

2024Nov15

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

FindImg_WShell

Finds the first image in a folder matching wild cards mask using WScript.Shell ...

2024Jul31

SwitchTextinCells

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

2024Feb23

VBInstrRev

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

2024Jan24

PivotTable_ShowHideBlankItems

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

2024Jan22

Excel clipboard bug

Looks like there is a bug in Excel when dealing with copy and paste. Excel ...

2023Dec27

Enable Includes in ASP Classic

Enable relative paths for ASP Classic includes to work. New servers do not ...

2023Aug7

Detailed errors - Web.config

Show detailed error using Web.config Was always struggling with the exact ...

2023May25

MapPath_SafeComma

MapPath version expecting comma in filename or folder. Just because we might ...

2023May19

NumberDigitImage

Creates list of images to represents a number. Basically multiple < img > tags ...

2023May15

DB Functions (By AI)

3 functions to add or update data to DB and Read from DB. These were also ...

2023Apr23

1 2 3 4