Hi,
Can any one point me in the right direction?
What I want to do is when I name a new range I want to check there isnt a range on the current sheet already with that name.
cheers
Ps Will this work?
Can any one point me in the right direction?
What I want to do is when I name a new range I want to check there isnt a range on the current sheet already with that name.
cheers
Ps Will this work?
Code:
Function NameExists(TheName As String) As Boolean
On Error Resume Next
NameExists = Len(ThisWorkbook.Names(TheName).Name) <> 0
End Function