Category: Handy Functions

A collection of ready-made handy functions to use in your own projects

Are All Characters Approved Characters?

CharsOnlyIn(StringToCheck, ApprovedCharacters) As Boolean
Quickly check all the characters in a string are in a list of approved characters. Can be used as a part of your data verification and cleansing processes.

Convert Column Letters to Column Numbers

ColLetToNum(ColumnLetter) As Integer
Convert column letter(s) to integers to make converting between range and cell references easier. Returns a 0 if the letter(s) can’t be converted to a numbers.

Convert Column Numbers to Column Letters

ColNumToLet(ColumnNumber) As String
Convert column numbers to letters to make converting between range and cell references easier. Returns an empty string if the number can’t be converted.