|
楼主 |
发表于 2013-6-6 13:26
|
显示全部楼层
本帖最后由 ak47ok 于 2013-6-6 13:30 编辑
KCFONG 发表于 2011-9-30 03:12
I had done a primary macro.
I think you can complete the other problem
I still not found out why
...
不知怎么回事,现在运行4楼的文件都是出错:下标越界(错误9)
If Trim(Range("a" & R)) Like "*【性状】*" Then
If Asc(Trim(Range("a" & R - 4))) < 65 Or Asc(Trim(Range("a" & R - 4))) > 122 Then
品名 = Range("A" & R - 4): 拼音 = Range("A" & R - 3): 英文 = Range("A" & R - 2): 简述 = Range("A" & R - 1)
ElseIf Asc(Trim(Range("a" & R - 5))) < 65 Or Asc(Trim(Range("a" & R - 5))) > 122 Then
品名 = Range("A" & R - 5): 拼音 = Range("A" & R - 4): 英文 = Range("A" & R - 3) & " " & Range("A" & R - 2): 简述 = Range("A" & R - 1)
End If
ARR(TR, 1) = Trim(品名): ARR(TR, 2) = Trim(拼音): ARR(TR, 3) = Trim(英文): ARR(TR, 4) = Trim(简述)
提示是最后一段中的 “ARR(TR, 2) = Trim(拼音)”出错
麻烦高手指点,谢谢!
|
|