Hello!
Can anyone help me with the following problem:
I have some ranges in my workbook, and I want to check if the content of a cell is the name of a range.
For example:
I have : range1
range2
range3
range4
range5
I want to see if ActiveCell.Offset(0,-2).Value is one of the named ranges in the workbook.
How can I make that check???
Thanks in advance,
Chris
Can anyone help me with the following problem:
I have some ranges in my workbook, and I want to check if the content of a cell is the name of a range.
For example:
I have : range1
range2
range3
range4
range5
I want to see if ActiveCell.Offset(0,-2).Value is one of the named ranges in the workbook.
How can I make that check???
Thanks in advance,
Chris