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

[µo°Ý] ½Ð±Ð if §PÂ_¦¡¤Óªø ¡A«ç»ò´«¦æ¡H

[µo°Ý] ½Ð±Ð if §PÂ_¦¡¤Óªø ¡A«ç»ò´«¦æ¡H

½Ð±Ð if §PÂ_¦¡¤Óªø ¡A«ç»ò´«¦æ¡H
if Cells(x_step, 15) = 20  or Cells(x_step, 15) = 235 or Cells(x_step, 15) = 25 or Cells(x_step, 15) = 207  then
  
Else

End if


Cells(x_step, 15) = 20  or Cells(x_step, 15) = 235 or _  ===========>¼g¦¨¨â¦æ¡A­n«ç»ò¼g¤X¡C
Cells(x_step, 15) = 25 or Cells(x_step, 15) = 207 then

·P®¦~~~¡CÁÂÁ¡C

¦^´_ 1# ji12345678
°Ñ¦Ò¬Ý¬Ý
  1. Sub test()
  2. If Cells(x_step, 15) = 20 Or Cells(x_step, 15) = 235 Or _
  3. Cells(x_step, 15) = 25 Or Cells(x_step, 15) = 207 Then
  4. End If
  5. End Sub
½Æ»s¥N½X

TOP

¦^´_ 1# ji12345678
  1. num2lookup = ",20,235,25,207,"
  2. if UBound(Split(num2lookup, "," & Cells(x_step, 15) & ",")) >0 then
  3. ......
  4. end if
  5.    
½Æ»s¥N½X
ss

TOP

¦h¥[­Ó  _   ²Å¸¹´N¥i¥H±µ¤U¦æ¤F¡I
Hi~

TOP

        ÀR«ä¦Û¦b : ¯u¥¿ªº·R¤ß¡A¬O·ÓÅU¦n¦Û¤vªº³oÁû¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD