Search results 430

Sorted from new to old.

MatchIf8Up

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

Wed 3PM

MatchIf7Up

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

Sat 8AM

MatchIf7

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

Fri 1PM

FirstDuplicatedItem

Returns the value of first duplicated item found in a range. This is to ...

Apr18

MatchIf4Up

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

Apr12

NumberBeforeString

Returns number if found before certain word in larger string. This can be used ...

Apr10

DateAdd_Networkdays

Adds workdays to a date using DateAdd It keeps adding days and checks how many ...

Apr6

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

DB Connection Drivers Test

Test connection to DB using different drivers to see which one works. You may ...

Mar12

ANmaSafeDeleteFile

Deletes file safely without warnings or error messages. Tries to delete it at ...

Mar10

ToggleCells

Toggle a value through list of cells in a range Pass current value and range ...

Feb2

HTMLTable_FindTable

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

Jan12

ANStrFind_AndOrRemove

Checks (and/or removes) if an item was found in list of items and return 1 if ...

Jan12

ANmaSearch_AllWords_FromANStr

Checks if string has all words from ANStr inside Retuns 0 if not found or ...

Jan8

ANmaSum_5IFs

Returns Sum conditionally of 5 columns (SumIFS), in a sheet, certain workbook ...

Jan8

1 2 ...26 27