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

[µo°Ý] ¦p¦óÅý¤½¦¡Âê©w¡A¤£·|¦]·|´¡¤J©Î°Å¤U²§°Ê¦ÓÅÜ

[µo°Ý] ¦p¦óÅý¤½¦¡Âê©w¡A¤£·|¦]·|´¡¤J©Î°Å¤U²§°Ê¦ÓÅÜ

Dear ¦U¦ì¥ý¶i,
Excel ¥i¥HÂê©w¤½¦¡¡A«ö¤UF4 ¡A¤½¦¡·|¥[¤W$¦r¸¹Âê©w"Äæ"¦C"

·Q¸ß°Ý¤@¤U¡A­Y§Ú·QÂê©w $A:$A
¦ý§Ú¤£·Q¦]¬°AÄæ¦ì´¡¤J¤@Äæ¦ì«á¡A¤½¦¡´N¦Û°Ê¶]¦¨¬°$B:$B
¤]´N¬O»¡¤£ºÞ§ÚªºAÄæ¦ìÅܨì­þ¸Ì¡A¤½¦¡¥Ã»·¸j¦í$A:$A
¬O§_¦³¿ìªk©O¡H
Just do it.

¦^´_ 1# jsc0518

§ä§ä INDIRECT ¨ç¼Æªº¥Îªk~~
INDIRECT("A1:A500")

TOP

¦^´_ 2# ­ã´£³¡ªL
Dear ­ã´£³¡ªL,

·PÁ±zªº¦^ÂСA§Ú¦b¤Wºô§äINDIRECT¨ç¼Æ¥¦ªº¬ÛÃö¥Îªk

·PÁ±z¡I ^^
Just do it.

TOP

        ÀR«ä¦Û¦b : §Ñ¥\¤£§Ñ¹L¡A§Ñ«è¤£§Ñ®¦¡C
ªð¦^¦Cªí ¤W¤@¥DÃD