asked on
How do I add to an array based on a Case?
Is it possible to set the values for an Array using a Case. For example
Select Case Range("A1").Value
Case B
v_WksNames = Array("RequirementSummary"
Case C
v_WksNames = Array("Reviewer1", "LOJ")
What if the range contains both B and C? Is it possible to make the array v_WksNames = Array("RequirementSummary"
Select Case Range("A1").Value
Case B
v_WksNames = Array("RequirementSummary"
Case C
v_WksNames = Array("Reviewer1", "LOJ")
What if the range contains both B and C? Is it possible to make the array v_WksNames = Array("RequirementSummary"
Microsoft Excel
Last Comment
Saqib Husain
If B an V are variables then the syntax looks ok. If they are values then enclose them in quotes "B" "C"
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Chris, the range("A1").Value could be "BC". So in that case the OP's hypothesis seems ok.
Saqib
Saqib
ssaqibh
Are you trying to say something is wrong?
Are you trying to say something is wrong?
I was just trying to respond to your statement
"Strictly speaking you can't since range("A1").Value cannot equal two different things..."
"Strictly speaking you can't since range("A1").Value cannot equal two different things..."