Search results 76

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

punycode

Encode or Decode Punycode used in domain names that are not in English ASCII ...

Jun8

ANmaCountChars_Direction

Counts how many times we found OfChar repeated in TheStr from one of two ...

May24

MatchIf7Up

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

May3

VBInstr_Rev_Any

Finds first match of string inside another in reverse order. From right to left ...

Apr11

VBInstr_SpaceFriends_BetweenHTMLTags

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

Mar13

VBA/Excel Registry hacks

Set of hacks to modify Excel/VBA settings using Windows registry (Regedit) ...

Mar12

HTMLTable_FindTable

Reads < table .... < /table> found after index Have ability to opnly bring the ...

Jan12

VBInstr_Occurance

Returns location of text inside another with jump ability for any certain ...

2024Dec1

Match6_Until

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

2024Nov28

VBInstr_Any

Returns the index where any of the words from AnStrSearchFor found in SearchIn ...

2024Nov17

VBInstr_Any

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

2024Nov15

Excel 2408 bug

Serious bug in Office update that was pushed Aug 26th. At least from Excel ...

2024Sep10

Get boot time

Get the last time Windows 10 was started. Needed this quickly for research.

2024Sep6

ANmaSearch_SpaceFriends and LeftSpaceFriends

Searches for string inside string covering multiple possibilities for space ...

2024Jul30

ANmaSearch_OrFriends

Search for one of items in SearchFor_ListOfFriends inside SearchIn and return ...

2024Jul30

1 2 3 4 5