Tag Archives: Functions

Using Exit Function in VBA

To start with, make sure you have a good understanding of what a function is and how it works. You can get a great overview in my articles here: What is “You’ve Entered too Many Arguments”? How Do You Fix “Compile Error: Argument not optional”?

Using the UCase Function in Excel VBA

There may be a time in Excel that you need data that you are fetching from an Excel spreadsheet or importing from external data to be amended to upper case.  This can, of course, be done manually, but if it is a large amount of

How to Use the VBA Replace Function

The VBA Replace function is a function which you can use in your code to replace one set of string characters with another set of string characters, or to replace a set of string characters with an empty string. For example, you may have a

IsNumeric in VBA: 8 Ways to Use the Function

In VBA, to test whether an expression is a number, the IsNumeric function can be used. Description The IsNumeric function evaluates whether the input expression is a number and returns a Boolean value (TRUE or FALSE). It returns True if the entire expression is a number; otherwise, it returns False. Syntax IsNumeric(expression) The

No Thumbnail

Excel Functions and Formulas, CHAR()

Each character is mapped to a numeric value. For example the character “A” is mapped to the number 65. The character “B” is mapped to the number 66 and so on. The CHAR() function receives an number as input and returns the character associated with that number. – Syntax: