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