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

[µo°Ý] §âªÅ®æ¶ñ¤J¸ê®Æ

[µo°Ý] §âªÅ®æ¶ñ¤J¸ê®Æ

¦U¦ì¤j¤j¦n
§Ú·Q½Ð°Ý¦p¦ó§âAÄ檺ªÅ¥Õ¦C¶ñ¤WA1²Ä¤@Ä檺¸ê®Æ,·í¦³AÄ椣¬°ªÅ¥Õ´N§ì¤U¤@µ§¸ê®Æ ³o¼Ë¶ñ¤J¦bÀx¦s®æ¤¤
³o¼Ë°µ±o¨ì¶Ü
³Â·Ð¤j¤j¨ó§U

qqqqq.png (4.33 KB)

´y­z¤@

qqqqq.png

QQQQ8.png (6.25 KB)

´y­z¤G

QQQQ8.png

¦^´_ 2# stillfish00


±z¦n §Ú¬Ý¤£¤ÓÀ´ Range("A1:B15").SpecialCells(xlCellTypeBlanks) = "=R[-1]C" ³o¬O¬Æ»ò·N«ä ÁÂÁÂÀ°¦£
Range("A1:B15").SpecialCells(xlCellTypeBlanks) = "=R[-1]C"
Range("A1:B15") = Range("A1:B15").Value

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡µLªk¾B¾×¡j©È®É¶¡®ø³u¡Aªá¤F³\¦h¤ß¦å¡A·QºÉ¦U¦¡¤èªk­n¾B¾×®É¶¡¡Aµ²ªG¬O¡G®ö¶O¤F§ó¦h®É¶¡¡A¥B¤@µL©Ò¦¨¡I
ªð¦^¦Cªí ¤W¤@¥DÃD