Random codes

Codes Required

Similar codes

MatchIf2Up

Search for 2 items in 2 columns starting from last row upword (Starting with ...

Apr29

ANmarAmdeen

MatchIfUp or MatchIfRev

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

Apr8

ANmarAmdeen

Match4_4thNot0

Searches for three cells in three columns then checks for 4th column if not ...

Nov1

ANmarAmdeen

ANmaSum_4IFs

Applies SumIFs for 4 columns, same sheet, same workbook Another function to do ...

Nov13

ANmarAmdeen

HMatchIf

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

2018Jun16

ANmarAmdeen

MatchIf5Up

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

May27

ANmarAmdeen

RangeValues

Returns values of all cells in range into 1 string Only non-blank values ...

2024Jan25

ANmarAmdeen

Match2

Matching by two values at the same time in two columns Just like Match the ...

2018Jun16

ANmarAmdeen

Match3_3rdNot0

Searches for two cells in two columns then checks for 3rd column if not equal ...

Nov2

ANmarAmdeen

Recently by developer

ToggleCells

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

Sun 3PM

ANmarAmdeen

Toggle5Values

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

Sun 6AM

ANmarAmdeen

PrevWeekday

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

Sat 6AM

ANmarAmdeen

TrimLines

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

Fri 6AM

ANmarAmdeen

ExtractNumeric_FromCell

Returns the number from an HTML cell after cleaning and finding sign. We faced ...

Aug6

ANmarAmdeen

CutString97

Cuts part from large string from certain character to certain character with ...

Jun5

ANmarAmdeen

Open different Filestypes

Populate list of filetypes in Application.GetOpenFilename method. This command ...

2019Jan9

ANmarAmdeen

HardDrivePartitionSN

Get Hard drive SN (old fashioned way) using FileSystemObject

2018Jun15

ANmarAmdeen