¼g¦bG3Àx¦s®æ
±N¦¹VBA¼gªk§ï¦¨¨ç¼Æ¼gªk
If Sheets("¤u§@ªí1").Cells(I, "D") < 0.5 Then
Sheets("¤u§@ªí1").Cells(I, "G") = "·s¤H"
ElseIf Sheets("¤u§@ªí").Cells(I, "F") = "³¯«³¨³" Or Sheets("Assy1").Cells(I, "F") = "¼B¼wµØ" Then
Sheets("¤u§@ªí").Cells(I, "G") = "leader"
ElseIf Sheets("¤u§@ªí1").Cells(I, "F") = "±i¾Ç¤Í" Or Sheets("¤u§@ªí").Cells(I, "F") = "³¢´I«°" Then
Sheets("¤u§@ªí1").Cells(I, "G") = "leader(¥N)"
ElseIf Sheets("¤u§@ªí1").Cells(I, "F") = "§õµOÄ£" Or Sheets("¤u§@ªí1").Cells(I, "F") = "³¢¥x»Ê" Or Sheets("¤u§@ªí1").Cells(I, "F") = "¤p½¼" Then
Sheets("¤u§@ªí1").Cells(I, "G") = "°V½mû"
ElseIf Sheets("¤u§@ªí1").Cells(I, "F") = "Í×´¼·½" Or Sheets("¤u§@ªí1").Cells(I, "F") = "¾¤©ú" Then
Sheets("¤u§@ªí1").Cells(I, "G") = "LAB±Mû"
ElseIf Sheets("¤u§@ªí1").Cells(I, "F") > 0.5 Then
Sheets("¤u§@ªí1").Cells(I, "G") = "¦Ñ³¾"
End If
Next |