Search results 266

Sorted from new to old.

UsedRange

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

Mon 1PM

1st cell of sheet range

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

Mon 1PM

MatchIf8

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

Sat 3PM

MathInsideText

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

Thu 1PM

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 < ...

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

ANmaRename2Files

Quick batch file to rename two files. One of my big sources of images for my ...

Mar16

VBInstr_SpaceFriends_BetweenHTMLTags

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

Mar13

DB Connection Drivers Test

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

Mar12

ToggleCells

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

Feb2

ANStrFind_AndOrRemove

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

Jan12

ANmaRemoveDuplicates2

Remove duplicated rows based on 2 columns in a table of any number of columns. ...

2024Dec4

Match6_Until

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

2024Nov28

Match4_Until

Search 4 columns with a stop. Tell the function to stop searching after certain ...

2024Nov22

1 2 ...16 17