Similar codes

code image
MatchIfUp or MatchIfRev

Searching for an item in a column from bottom to top. Will search for item in ...

Apr8

code image
MatchIf6Up

Searches for 6 values in 6 columns and return the row number found in. ...

May31

code image
MatchIF5

Searching for rows having 5 values in 5 columns Like

May6

code image
MatchIf5Up

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

May27

code image
MatchIf6

Searching for row have 6 matches found in 6 different columns, because we had 5, ...

May31

code image
Match6_Until

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

Nov28

code image
CellRead (SimpleLookup)

Simply reading a value from a specific cell from a sheet from a workbook ...

2018Jun25

code image
HMatchIf

Horizontal match for a value in a row Horizontal MatchIf, returns column ...

2018Jun16

code image
MatchLastIf

Finds last occurrence of a match in a column Finds the row of last time an ...

2019Jun12

Recently by developer

code image
ToggleCells

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

Feb2

code image
Toggle5Values

Toggles among up to 5 values. Pass the current values, then up to 5 values (in ...

Feb2

code image
PrevWeekday

Returns date of the previous weekday (Friday, Saturday, Sunday, etc) from ...

Feb1

code image
TrimLines

Remove all line breaks from text from a text. Not like

Jan31

Random Codes

code image
SubZero

Forces Excel to not convert numbers during moving them across sheets, or ...

2023May23

code image
Global asa

As ASP Classic user, I have to have some post about global.asa Here is one, ...

2018Dec28

code image
Capitalize1st

Capitalize 1st letter of a string

2018Jul15

code image
KillFile

Deletes a file, using mapped or unmapped file path

2018Apr21