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

[µo°Ý] ½Ð°Ý¯à§_¥HÅܼƨú¥Nµ{¦¡½X

[µo°Ý] ½Ð°Ý¯à§_¥HÅܼƨú¥Nµ{¦¡½X

¤j®a¦n¡G
§Úªº¤@¬qÃþ¦ü¥H¤Uªºµ{¦¡½X
ActiveSheet.Cells(f, 4).FormulaR1C1 = "=IF(OR(RC[3]=1,RC[6]=""""),"""",1)"
·Q¥HÅܼƳo¼Ëªº¤è¦¡¨Ó¨ú¥N
µM«á¦b¥[¥H¤Þ¥Î
¤£ª¾¥i¤£¥i¦æ
ÁÂÁÂ~~~

¦^´_ 1# mygod0403
¬O³o¼Ë¶Ü?
ActiveSheet.Cells(f, 4) =ÅܼÆ

TOP

¦^´_ 1# mygod0403


x = IIf(Cells(f, "G") = 1 Or Cells(f, "J") = "", "", 1)
Cells(f, 4) = x
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¦n¨Æ­n´£±o°_¡A¬O«D­n©ñ±o¤U¡A¦¨´N§O¤H§Y¬O¦¨´N¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD