Will add hyperlink in a cell to a sheet in same workbook Not Hyperlink ...
2018Jun24
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
How to copy formulas in VBA code. Learned that the hard way, just like most of ...
2019Oct3
Counts how many cells in a column in any sheet, any workbook using COUNTIF ...
2018May23
Fill in formulas from 1st row, then convert them to flat values to avoid Excel ...
2018Jun30
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
Find the user name (and domain) for logged in user for in an internal intranet ...
2020Feb23
Adds a sheet to a workbook, after checking if workbook is open Checks if ...
2019Apr1