VBA: Checking if a Cell is Named

[James_B]

Dear All,

Programatically speaking, can anyone think of a way of checking whether an arbitrary cell is part of a named range (that is, short of looping through an entire book's named ranges checking for intersections)? (If it helps, it can be assumed that all the named ranges consist only of one cell).

Cheers for any and all (sensible) ideas,

James.

 

[wigi]

Hello

As far as I know, there is no different and elegant way. (don't know if it works but you wouldn't want to select the cell and then use the API to determine the contents of the Name Box, to the left of the formula bar).

 

[circledchicken]

Hi,

I might be missing the point but perhaps try:

ActiveCell.Name.Name - and use relevant error handling for unnamed cells

 

[wigi]

I stand corrected. Nice suggestion circledchicken.

 

[circledchicken]

I stand corrected. Nice suggestion circledchicken.

Thanks!

 

[James_B]

Exactly what I was after. Thanks a bunch. (Thanks for the thoughts too, Wigi. Though I don't imagine I'll be pursuing your API-based suggestion any time soon! )

 

[circledchicken]

Exactly what I was after. Thanks a bunch. (Thanks for the thoughts too, Wigi. Though I don't imagine I'll be pursuing your API-based suggestion any time soon! )

Your welcome!