Random codes

Similar codes

End ( xlDown )

A bug found because of using End(xlDown) Please stop using Range("A1"). ...

Aug28

ANmarAmdeen

RangeValues

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

Jan25

ANmarAmdeen

SortArea1

Sorts a range or area by 1 column given its cell address, with options to ...

2018Jul4

ANmarAmdeen

IsError_Range

Checks if range has at least one error in a range of cells Fast, and simple

2021Dec30

ANmarAmdeen

CountDuplicates

Counts how many duplicates found in a range of Excel cells. Basically how many ...

2020Oct31

ANmarAmdeen

CopyFormat

Applies format into a cell (or range) from another cell. Can apply from any ...

2018Aug10

ANmarAmdeen

RemoveDuplicates

Removes duplicated items from a 1-dim array into new array, does not modify ...

2022Jul7

ANmarAmdeen

SortArea5

Sort range or area by 5 columns, range can be any number of columns, but the ...

2018Jul5

ANmarAmdeen

SortArea3

Sort range or area by 3 columns, range can be any number of columns, but the ...

2018Jul4

ANmarAmdeen

Recently by developer

MatchIF5

Searching for rows having 5 values in 5 columns Like

May6

ANmarAmdeen

CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

May1

ANmarAmdeen

Files_FoundHours

Listing the file from a folder that was created during last few hours. Can ...

Apr30

ANmarAmdeen

MatchIf2Up

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

Apr29

ANmarAmdeen

CutLeftNumber

Cuts the left part of string as long as it is number Keeps getting characters ...

Dec31

ANmarAmdeen

Functions.dll

Old DLL housing list of functions to be used and called by any application, ...

2020Jul18

ANmarAmdeen

Windows Clock

Restore Windows 10 clock to Windows 7 Analog clocks

2019Jun28

ANmarAmdeen

CreateFullTree

Creates full tree if not found

2018Jul9

ANmarAmdeen