Refering to a particular cell in a Named Range
If Not IsError(Application.Match(Range("C5").Value, Range("Locations"),0))
Then
MsgBox Application.Match)Range("C5").Value, Range("Locations"),0) ' the
index within Locations
End If
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Corey ...." wrote in message
...
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....
|