Similar codes

Card image cap
End ( xlDown )

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

Aug28

Card image cap
RangeValues

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

Jan25

Card image cap
SortArea1

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

2018Jul4

Card image cap
IsError_Range

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

2021Dec30

Card image cap
CountDuplicates

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

2020Oct31

Card image cap
CopyFormat

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

2018Aug10

Card image cap
RemoveDuplicates

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

2022Jul7

Card image cap
SortArea5

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

2018Jul5

Card image cap
SortArea3

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

2018Jul4

Recently by developer

Card image cap
MatchIF5

Searching for rows having 5 values in 5 columns Like

Mon 5PM

Card image cap
CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

May1

Card image cap
Files_FoundHours

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

Apr30

Card image cap
MatchIf2Up

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

Apr29

Random Codes

Card image cap
3 Custom BS buttons

3 Custom-made button colors using Bootstrap. Because I suck at graphics, I ...

Jan21

Card image cap
Bootstrap Media player controls

Controls for a media player using Bootstrap and FontAwesome

2019Sep15

Card image cap
Magick SVGs to GIFs

Convert SVG files into GIF preserving the transparency, in bulk ' Used to ...

2019Sep5

Card image cap
FrmAbout

Display a string in a Userform as 'About' window, can display string or file by ...

2018Jun11