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

Mon 5PM

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

FontAwesome icons in Office apps

Best way to use FontAwesome set of icons in apps, mainly my Excel tools and ...

2023Jan31

ANmarAmdeen

InSheet_ChangeImage

Allows users to inserts image into sheet, replacing old one, with ability to ...

2021Feb20

ANmarAmdeen

Tabs19-BS3

Rounded tabs control in Bootstrap 3

2019Apr19

ANmarAmdeen

ANmaTimeline

Creates HTML timeline dynamically, using Bootstrap 4.0 and FontAwesome 5, in a ...

2018Aug26

ANmarAmdeen