I have a range of 4 cells. Each cells can contain a particular phrase. I would like to use a case to identify if there is a string in any of the cells in the Range. Current the code can only look at one of the cells at a time. The code:
Select Case Range("Rd_Reviewer1ReqBy_Attachment1").Value
Case "LOJ"
v_WksNames = Array("RequirementSummary", "Reviewer1", "LOJ")
Call M_CreateMultiWksFile(v_WksNames)
Case "Review File - ACO"
v_WksNames = Array("Reviewer2")
Call M_CreateMultiWksFile(v_WksNames)
Case "Review File - Camp Mayor"
v_WksNames = Array("Reviewer3")
Call M_CreateMultiWksFile(v_WksNames)
Case "Review File - Chief of Staff Approving O6"
v_WksNames = Array("Reviewer8")
Call M_CreateMultiWksFile(v_WksNames)
End Select
Any help would be much appreciated.
if cell1="..." then
.....
elseif cell2="..." then
.....
elseif cell3="..." then
.....
elseif cell4="..." then
.....
endif