I've got this piece of code to check if a cell is within a range but I'm using it against a pre-defined table, just curious if there is any built-in function for doing this?
At the mo I'm thinking of making my own function based on the code below.
-adehhVB Code:
If Application.Intersect(Range("B5"), ActiveWorkbook.Names("drivers").RefersToRange) Is Nothing Then MsgBox "B5 is not in drivers range table" Else MsgBox "B5 is in drivers range table" End If
