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.
Our community of experts have been thoroughly vetted for their expertise and industry experience.
The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.