Returns the formula for a hyperlink [=Hyperlink(...) ] to be inserted in a cell. ...
2022Aug24
Creates a hyperlink to URL or to cell inside a cell in Excel VBA (or delete it). ...
2018Aug9
An issue I started to see when clicking on a hyperlink in Excel 2010, while I ...
2019Jun16
Applies format into a cell (or range) from another cell. Can apply from any ...
2018Aug10
Counts how many cells in a column in any sheet, any workbook using COUNTIF ...
2018May23
Adds a sheet to a workbook, after checking if workbook is open Checks if ...
2019Apr1
Counts how many cells matching 2 criterias.
Just like
Wed 7AM
Listing the file from a folder that was created during last few hours. Can ...
Tue 7AM
Finds the location of a sting inside list of strings with certain separator, or ...
Apr23
Convert SQL View into table for speed reading. Using views a lot, I needed a ...
Jul19
Show an image using irfanview or Windows 7 image viewer. Looking to add more ...
2020Feb16
An aspx tool to generate thumbnail from an image, used to make page load faster ...
2018Aug10