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

½Ð°Ý­n¦p¦ó±Nhseetname ±a¤J¤½¦¡¸Ì

½Ð°Ý­n¦p¦ó±Nhseetname ±a¤J¤½¦¡¸Ì

½Ð°Ý¦p¦ó±Nsheetname ±a¤J¡A°²³]§Ú¦³20±isheet ,
²Ä20±i¶}©l­n±N«e19±i±a¤Jb130, b131........
½Ð°Ý­n¦p¦ó±Nhseetname ±a¤J

Range("B130").Select
    ActiveCell.FormulaR1C1 = "='sheets1'!R[158]C[6]"

ÁÂÁÂ

·Q³q¤F¡A±Nsheetname ©ñ¤J¬Y­Ó ¦ì¸m¡A
¦A±Nabc «ü©w¹L¥h§Y¥i

ActiveCell.FormulaR1C1 = "='" & ABC & "'!R[158]C[6]"

TOP

        ÀR«ä¦Û¦b : ºÉ¦h¤Ö¥»¥÷¡A´N±o¦h¤Ö¥»¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD