Function Check Multiple Named Ranges Exist

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

Tags: developer, function

Categories: vba

Updated: November 16, 2018

Twitter Facebook LinkedIn

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

Leave a Comment