Similar codes

Card image cap
HyperlinkFunction

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

2022Aug24

Card image cap
CellSave_Hyperlink

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

2018Aug9

Card image cap
InsertHyperlinks+GetHref

Changes all URLs or email addresses in a text into hyperlinks

2018Apr23

Card image cap
Excel 2010 hyperlink issue fix

An issue I started to see when clicking on a hyperlink in Excel 2010, while I ...

2019Jun16

Card image cap
CopyFormat

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

2018Aug10

Card image cap
SortArea1

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

2018Jul4

Card image cap
a href=#

Instead of using href="#", it is better to use href="javascript:void(0);" to ...

2018Sep12

Card image cap
CountColumnCells + CountColumnCells_Criteria

Counts how many cells in a column in any sheet, any workbook using COUNTIF ...

2018May23

Card image cap
SheetAdd_ANmar

Adds a sheet to a workbook, after checking if workbook is open Checks if ...

2019Apr1

Recently by developer

Card image cap
ANmaHTMLTables_Combine2

Combine strings of two HTML tables into string of one table.

Thu 3PM

Card image cap
MatchIF5

Searching for rows having 5 values in 5 columns Like

May6

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

Random Codes

Card image cap
CutString_ReverseFrom

Returns full string starting from the point of LocIndex minus back where we ...

Feb27

Card image cap
Bootstrap3 modal Contextual colors

Bootstrap3 Contextual colors modal dialog From

2019May19

Card image cap
User-Defined Formatting

Apply special Conditional Formatting, color cells based on their values. This ...

2019Jan9

Card image cap
Shrinking DB

Steps to shrink database in MS SQL

2019Jan6