upper問題請教
dear all 大大1.涵數大寫使用 UPPER
2.圖一 If Sheet3.Cells(M, 4) Like "*" & "uball" & "*" Then 我用 If UPPER(Sheet3.Cells(M, 4)) Like "*" & "uball" & "*" Then 不能用
2.1請問UPPER(Sheet3.Cells(M, 4))要改甚????
煩不另賜教 THANS*10000
圖一
Sub 模型mod自動比對4()
Sheet6.Visible = True
Sheet6.Select
Range("L974").Select
Sheet6.[O976:O985].ClearContents
X = Sheet3.[D65536].End(xlUp).Row
Y = 975
For M = 1 To X
If Sheet3.Cells(M, 4) Like "*" & "uball" & "*" Then
Sheet6.Cells(Y + 1, 15) = Sheet3.Cells(M, 4)
Y = Y + 1
End If
Next
End Sub [quote]dear all 大大
1.涵數大寫使用 UPPER
2.圖一 If Sheet3.Cells(M, 4) Like "*" & "uball" & "*" Then ...
[size=2][color=#999999]rouber590324 發表於 2021-11-2 14:17[/color] [url=http://forum.twbts.com/redirect.php?goto=findpost&pid=117557&ptid=23463][img]http://forum.twbts.com/images/common/back.gif[/img][/url][/size][/quote]
涵數大寫使用UPPER，VBA要改為 UCase DEAR samwang 大大
UCase 可用 感恩 THANKS*10000
頁:
[1]