我在一小段代码中有三个不同的CASE,每个都有一个围绕For...Next循环的例程的微小变化。问题是,根据嵌套方式的不同,效率和速度是否会有所不同?
换句话说,就是:
Select Case sPosition
Case Is = "First"
For j = 17 to 65
[Do stuff]
Next j
Case Is = "Middle"
For j = 17 to 65
[Do stuff]
Next j
Case Is = "Last"
For j = 17 to 65
[Do stuff]
Next j
End Select...any效率或多或少超过:
For j = 17 to 65
Select Case sPosition
Case Is = "First"
[Do stuff]
Case Is = "Middle"
[Do stuff]
Case Is = "Last"
[Do stuff]
End Select
Next jhttps://stackoverflow.com/questions/38329593
复制相似问题