Codes Required

Similar codes

Card image cap
HyperlinkFunction

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

2022Aug24

ANmarAmdeen
Card image cap
Range2Block

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

2023Mar6

ANmarAmdeen
Card image cap
SortArea1

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

2018Jul4

ANmarAmdeen
Card image cap
End ( xlDown )

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

Aug28

ANmarAmdeen
Card image cap
InsertHyperlinks+GetHref

Changes all URLs or email addresses in a text into hyperlinks

2018Apr23

JeffSmith
Card image cap
CopyFormat

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

2018Aug10

ANmarAmdeen
Card image cap
CellSave_Hyperlink

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

2018Aug9

ANmarAmdeen
Card image cap
CellRead (SimpleLookup)

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

2018Jun25

ANmarAmdeen
Card image cap
SwitchTextinCells

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

Feb23

ANmarAmdeen

Recently by developer

See more
Card image cap
MatchIF5

Searching for rows having 5 values in 5 columns Like

Mon 5PM

ANmarAmdeen
Card image cap
CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

May1

ANmarAmdeen
Card image cap
Files_FoundHours

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

Apr30

ANmarAmdeen
Card image cap
MatchIf2Up

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

Apr29

ANmarAmdeen

Random Codes

See more
Card image cap
DateDiff_En

Calculates the differences of date (against NOW) and return in English ...

2022Mar3

ANmarAmdeen
Card image cap
Delete_Unwanted_Rows

Delete rows in a different way I used to delete rows by looping through those ...

2020Apr14

ANmarAmdeen
Card image cap
Easy Select

A drop down menu for Text fields Another one, that needs some work to fulfill ...

2019Jun25

ANmarAmdeen
Card image cap
Import error log

Imports the SQL Server error log into a table, so that it can be queried This ...

2018Sep29

ANmarAmdeen