I need to do some validations on a spreadsheet, and am using different named ranges for the data input areas.
My problem is when a user enters data, how do i identify which named range the cell is in without trawling through all the range names and comparing the addresses with the current cell? I've looked everywhere but can't find any way to do this. I'm using a Worksheet_Change event procedure, ideally I'd like to use a Name_Change event, but there doesn't seem to be any such thing.
Any advice gratefully received.
Ben
My problem is when a user enters data, how do i identify which named range the cell is in without trawling through all the range names and comparing the addresses with the current cell? I've looked everywhere but can't find any way to do this. I'm using a Worksheet_Change event procedure, ideally I'd like to use a Name_Change event, but there doesn't seem to be any such thing.
Any advice gratefully received.
Ben
