Random codes

Codes Required

Similar codes

HyperlinkFunction

Returns the formula for a hyperlink [=Hyperlink(...) ] to be inserted in a cell. ...

2022Aug24

ANmarAmdeen

Range2Block

Concatenate all rows found in a range starting A1Cell for Columns_To columns ...

2023Mar6

ANmarAmdeen

SortArea1

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

2018Jul4

ANmarAmdeen

End ( xlDown )

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

Aug28

ANmarAmdeen

InsertHyperlinks+GetHref

Changes all URLs or email addresses in a text into hyperlinks

2018Apr23

JeffSmith

CopyFormat

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

2018Aug10

ANmarAmdeen

CellSave_Hyperlink

Creates a hyperlink to URL or to cell inside a cell in Excel VBA (or delete it). ...

2018Aug9

ANmarAmdeen

CellRead (SimpleLookup)

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

2018Jun25

ANmarAmdeen

SwitchTextinCells

Switch text inside cells with another text. This was needed to correct an bug ...

Feb23

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

MapPath_SafeComma

MapPath version expecting comma in filename or folder. Just because we might ...

May19

ANmarAmdeen

Old cell value

Nice solution to read value in cell AFTER changed. Needed to have that feature ...

2021Dec30

ANmarAmdeen

Loading boxes

CSS based loader, spinner, loading animation

2019Jan5

ANmarAmdeen

FileSize_Formatted

Returns file size in formated human way (mb, gb, etc..) Or, it can format any ...

2018Apr25

ANmarAmdeen