View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Corey ....[_2_] Corey ....[_2_] is offline
external usenet poster
 
Posts: 45
Default Refering to a particular cell in a Named Range

I have a named range in sheet2 called "Locations"

In sheet 1 i use a validation dropdown list on required cells to list the
Location values.
I am trying to identify IF the value chosen was a particular item from the
"Locations" list.

"Locations" = Sheet2 A1-A12

I selected the first value in the list in the Validation List in Sheet1
(which is actally Sheet2 A1)

How can i capture the correct cell value chosen?
If Range("C5").Value = Locations(Cells(1)) Then ' <=== ???
'do stuff here
end if


Corey....