ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] upper°ÝÃD½Ð±Ð

[µo°Ý] upper°ÝÃD½Ð±Ð

dear  all ¤j¤j
1.²[¼Æ¤j¼g¨Ï¥Î 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))­n§ï¬Æ????
     ·Ð¤£¥t½ç±Ð  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
ù

dear  all ¤j¤j
1.²[¼Æ¤j¼g¨Ï¥Î UPPER
2.¹Ï¤@   If Sheet3.Cells(M, 4) Like "*" & "uball" & "*" Then   ...
rouber590324 µoªí©ó 2021-11-2 14:17


²[¼Æ¤j¼g¨Ï¥ÎUPPER¡AVBA­n§ï¬° UCase

TOP

DEAR samwang ¤j¤j
UCase  ¥i¥Î ·P®¦  THANKS*10000
ù

TOP

        ÀR«ä¦Û¦b : ¡i®É¤é²öªÅ¹L¡j¤@­Ó¤H¦b¥@¶¡°µ¤F¦h¤Ö¨Æ¡A´Nµ¥©ó¹Ø©R¦³¦hªø¡C¦]¦¹¥²¶·»P®É¶¡Ävª§¡A¤Á²ö¨Ï®É¤éªÅ¹L¡C
ªð¦^¦Cªí ¤W¤@¥DÃD