請問如何改寫 ASC("A") 只能讀A-Z共26個字母..
For j = 0 To 100j2 = Asc("A") + j
If Range(Chr(j2) & "8").Value = "" Then Exit For
Next
j2 = j2 - 1
請問如何改寫 ASC("A") 只能讀A-Z共26個字母?改用別的函數? [b]回復 [url=http://forum.twbts.com/redirect.php?goto=findpost&pid=110425&ptid=22220]1#[/url] [i]srd0k9[/i] [/b]
把range换成cells(行,列).value=""试试看?
頁:
[1]