Excel VBA: Display File Name as Hyperlink

In this article we will show you how to display file name as a hyperlink to a file in Excel. We first introduced this concept in this article but will expand upon it here. For this we will use the Hyperlinks.Add Method. Let’s have a

Data type mismatch in criteria error box

ByRef Argument Type Mismatch Error: Fixes

In this article, we will look at the ByRef argument type mismatch error. First, let us have a look at what is ByRef and the difference between ByRef and ByVal. In Visual Basic, you can pass an argument to a procedure or function by value or