Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Excel - Testing if a cell is in a Named range
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...- BENC
- Thread
- Replies: 0
- Forum: VBA Visual Basic for Applications (Microsoft)
