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

[µo°Ý] Àx¦s®æ®æ¦¡¤º®e°ÝÃD½Ð±Ð

[µo°Ý] Àx¦s®æ®æ¦¡¤º®e°ÝÃD½Ð±Ð

DEAR ALL¤j¤j
1. Sheet4.Range("B4") = 400
2.¤p§Ì¼g If Sheet5.Cells(M, 23) = "400" Then  µ{¦¡¥i°õ¦æ
    ¦ý¼g¦¨   If Sheet5.Cells(M, 23) = Sheet4.Range("B4") Then  µ{¦¡µLªk°õ¦æ
3.WHY ·Ð¤£§[½ç±Ð   THANKS*10000
ù

DEAR ALL¤j¤j
1. Sheet4.Range("B4") = 400
2.¤p§Ì¼g If Sheet5.Cells(M, 23) = "400" Then  µ{¦¡¥i°õ¦æ
...
rouber590324 µoªí©ó 2015-4-30 14:54

¬Ý¤£¥X¨Ó¦³¬Æ»ò°ÝÃD©O? (ÁöµM§Ú²ßºD¨Ï¥Î Sheets("Sheet5") ªº§Î¦¡,¤£¹L¦b Excel 2003 ¤¤½T©w Sheet5 ªº§Î¦¡¥i¥H¥Î)
§Ú¦b§Y®É¹Bºâ¦¡µ¡ª½±µ°õ¦æªº±¡§Î¦p¤U:

?Sheet1.Cells(1, 23) = Sheet2.Range("B4")
True

¤£ª¾§A©Ò¿×ªº "µ{¦¡µLªk°õ¦æ" ¬O«ç¼Ëªº±¡§Î?
¦³¥X²{¿ù»~°T®§¶Ü?¥X²{ªº¤S¬O¤°»ò¿ù»~°T®§©O?
¤S©ÎªÌ¬O°õ¦æµ²ªG¤£¦p§Aªº¹w´Á?
¨Ì¾Ú§Úªº²q´ú³o­Ó«ü¥O­Y·|¥X¿ù¥i¯à­ì¦]¤j·§¦³¥H¤U´XºØ:
1. ¦WºÙ¬° Sheet5 ©Î Sheet4 ªº ¬¡­¶Ã¯ ¤£¦s¦b.
2. °õ¦æ¦¹«ü¥O·í®Éªº M ­È¬° 0, ­t¼Æ, ªÅ­È, ÅÞ¿è­È, °}¦C ¥ç©Î¬O ¤å¦r.
3. ¨ä¤W¤U¼h(With, For,If,...µ¥)«ü¥O¥¼¦¨¹ï
4. ¦]µ¥¸¹¨âÃäÀx¦s®æ¤º®e(©Î®æ¦¡)¾É­PµLªk¤ñ¹ïªº±¡§Î.
...
¥i¯à©Ê¨ä¹êº¡¦hªº,
»Ý­n§ó¦hªº°T®§¤~®e©ö§PÂ_°ÝÃDÂI.
³Ì¦n¬O¯à´£¨Ñ¸û§¹¾ãªº½d¨ÒÀÉ®×¥H«K§PŪ.

TOP

DEAR  luhpro  ¤j¤j
·PÁ±z¸Ô²Ó¤§»¡©ú  THANKS*10000
ù

TOP

¦^´_ 1# rouber590324


    400¤£µ¥©ó"400"¡A³o¬O§A°ÝÃD©Ò¦b

TOP

DEAR  luhpro  ¤j¤j
·PÁ±z¸Ô²Ó¤§»¡©ú ¤p§Ì­×§ï¬° -400=0  ¤wOK   THANKS*10000

Sheet5.Cells(M, 37) - Sheet4.Range("B10") = 0
Sheet5.Cells(M, 37) - 400 = 0
ù

TOP

§ï¦¨¥H¤U³o¼Ë¤]¥i¥H¶]­ò ±z¸Õ¸Õ¬Ý
If val(Sheet5.Cells(M, 23)) = Sheet4.Range("B4") Then ..

TOP

DEAR gn001038600  SIR
¦h¨Ç¤@©Û  THANKS*10000
ù

TOP

        ÀR«ä¦Û¦b : ­n§åµû§O¤H®É¡A¥ý·Q·Q¦Û¤v¬O§_§¹¬üµL¯Ê¡C
ªð¦^¦Cªí ¤W¤@¥DÃD