作业帮 > 综合 > 作业

excel vba中if then语句中then后面加goto,

来源:学生作业帮 编辑:作业帮 分类:综合作业 时间:2024/05/12 03:37:53
excel vba中if then语句中then后面加goto,
程序如下:tjn = 1
For tjm = 16 To 45
For tjl = 6 To 230
If Sheets("sheet1").Cells(tjl,2) = tjx(tjn) Then
Sheets("sheet1").Cells(5,tjm) = tjx(tjn),GoTo tjlifend
Next
tjlifend:
tjm = tjm + 1
tjn = tjn + 1
Next
我想if then 的then后面同时执行Sheets("sheet1").Cells(5,tjm) = tjx(tjn),
GoTo tjlifend,但是跟在后面的话不属于IF?逗号连接报错.高手们感激不尽
Sheets("sheet1").Cells(5,tjm) = tjx(tjn)
GoTo tjlifend
分两行就行