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

Range22DimArray

Imports a range into 2-dimension array. Returns the array, providing range, ...

2023May11

ANmarAmdeen

ToggleSwitch in CSS

CSS Toggle switch, to show selection in CSS beautiful graphics It is basically ...

2019Jan15

ANmarAmdeen

AmIMobile

Check if browser is for a mobile or tablet, or not. This was before we have ...

2018Aug8

ANmarAmdeen

RemoveHTML

Removes HTML code Basically anything between < and > There is a better ...

2018May26

ANmarAmdeen