比如说有表1、表2一直到表10这10张表,用for each sht in worksheets的话会所有表都循环,现在只需要循环里面固定几张表(比如说表2、表5、表7三张表),要怎么写?
æ¹æ³ä¸ï¼
for each st in sheets(array("表2","表5","表7"))
æ¹æ³äºï¼
for each i in array(2,5,7)
stn="表" & i
set sht=sheets(stn)
for each st in sheets(array("表2","表5","表7"))
æ¹æ³äºï¼
for each i in array(2,5,7)
stn="表" & i
set sht=sheets(stn)
温馨提示:答案为网友推荐,仅供参考