troubleshooting Question

How do I identify different strings in a Range with a Case?

Avatar of AFGPHXExcel
AFGPHXExcel asked on
Microsoft Excel
2 Comments1 Solution269 ViewsLast Modified:
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.
Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros