ªð¦^¦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 : ¸Ü¦h¤£¦p¸Ü¤Ö¡A¸Ü¤Ö¤£¦p¸Ü¦n¡C
ªð¦^¦Cªí ¤W¤@¥DÃD