代码如下
If "j" & i = "" Then 'DM
Range("as" & i) = ""
Else
Range("as" & i) = "【1】DM;“ & vbCrLf
End If
输出结果不管对应单元格有没有值都输出为
”【1】DM;“
ä½ çè¿ä¸ªè¯å¥ç¨äºé½ä¸æç«ï¼
If "j" & i = "" Then 'DM
å¦æi为å¤å°ï¼ç»æè³å°æ¯j*ï¼ä¸å¯è½ä¸ºç©ºï¼æä¼°è®¡ä½ çæææ¯å¤æj*åå æ ¼çå¼å§ï¼é£ä¹è¯å¥åºè¯¥æ¯ï¼
If Range("j" & i) = "" Then 'DM
If "j" & i = "" Then 'DM
å¦æi为å¤å°ï¼ç»æè³å°æ¯j*ï¼ä¸å¯è½ä¸ºç©ºï¼æä¼°è®¡ä½ çæææ¯å¤æj*åå æ ¼çå¼å§ï¼é£ä¹è¯å¥åºè¯¥æ¯ï¼
If Range("j" & i) = "" Then 'DM
温馨提示:答案为网友推荐,仅供参考