less than 1 minute read
Function to check if multiple named ranges exist
'==============================================================================
' ## Function: Check multiple named ranges exist
'==============================================================================
Function RangeExists(s As String) As Boolean On Error GoTo myExit RangeExists = Range(s).Count > 0
myExit:
End Function ' Function example:
Sub CheckRanges() Dim vNames As Variant, v As Variant vNames = Array("ABC", "DEF", "GHI", "JKL", "MNO") For Each v In vNames Debug.Print v, RangeExists(CStr(v)) Next
End Sub
Categories: vba
Updated: November 16, 2018
1 minute read
Here’s the simple steps to highlight the row and column of the selected cell which can be extremely useful when navigating large sets of data. Here’s a littl…
less than 1 minute read
How it Works Using SEARCH and ISNUMBER When you need to check if a cell contains specific text (or string) we need to combing the SEARCH and ISNUMBER functio…
less than 1 minute read
So you have a 0% value on one of your data labels and want to hide it?
1 minute read
Download the example workbook here: calculate-time-between-dates.xlsx