MK613012000019 "MK6130120" 和“9”是定值,0001为四位数编码
MK613012000029
MK613012000039
MK613012000049
MK613012000059
MK613012000069
MK613012000079
MK613012000089
MK613012000099
MK613012000109
MK613012000119
MK613012000129
MK613012000139
MK6130120 + Format(编号, "0000") + "9"
For 编号 = 1 To 13
MsgBox "MK6130120" + Format(编号, "0000") + "9"
Next