Search results 224

Sorted from new to old.

Create Tree from 3 columns (Sheet2Tree)

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

Aug7

CutString_JsonKeyValue

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

Jul27

Icon as text - CmdCaption_ChrW

Creates an icon as text to use inside button or any frm20 controls. this will ...

Jul17

UnicodeToChrW

Converts a unicode number into its ChrW text. It automatically uses surrogate ...

Jul17

ASPZip

Zipping in ASP Classic, would love to test on my next project.

Jun6

Non-English IDNs

Online tool to encode or decode IDNs Domain names with characters other than ...

Jun4

Header font name and size in VBA

Looks like it is not easy to change font name, size and style for a header or ...

Jun1

Str2Clean

Cleans string. Just another function to clean string from unwanted characters

May22

UsedRange

Returns the address of first:Last cells with data in sheet. Like pressing ...

May12

1st cell of sheet range

Returns the address of first cell in data in range, the very first cell of very ...

May12

MatchIf8

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

May10

MathInsideText

Return string after applying math to each number found inside the string. ...

May8

MatchIf8Up

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

May7

MatchIf7Up

Returns row number having 7 values in 7 columns if all found. With option of < ...

May3

MatchIf7

Finds the row of 7 columns matching 7 values with options of < > <> and <= ...

May2

MatchIf4Up

Returns row of matching 4 values in 4 columns searching from bottom to top. ...

Apr12

1 2 ...13 14