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

°»¿ù , ¤£À´¥¦¿ùªº©w¸q­n¦p¦ó­×§ï ?

°»¿ù , ¤£À´¥¦¿ùªº©w¸q­n¦p¦ó­×§ï ?

' «Ø¥ß¬d¸ß³sµ²
Sub «Ø¥ß¬d¸ß³sµ²()

With Sheets("List")
.Activate
LastRow = .Cells(1, "A").End(xlDown).Row - 1

For r = 2 To LastRow
.Cells(r, "K").Select
IdSheet = .Cells(r, "A")
Sheets("IdSheet").Select.Activate

Next r

End With

End Sub

¥i¥H¸Õ¸Õ¬Ý §â
.Activate
¬å±¼ ¥u¯d
.Select

TOP

¦^´_ 2# k123456770


    ÁÂÁ¦^ÂÐ ,
    ÁÙ¬O¬å±¼­«ÀY¨Ó¹L¤F .........

TOP

­«ÀY¼g¹L
¬O§_´N¬O¤Ö¤F
.Activate
¤~¥¿±`?

TOP

¤u§@ªí sheets ªº¥i¥H¥Î activate ¶Ü?
À³¸Ó¬O­n¥Î select §a

TOP

¦^´_ 5# sghsgh1111

ÁÂÁ , §ÚCOPY¨ÓCOPY¥h , ©Ò¥H¤£ª¾°ÝÃD¦p¦ó¸Ñ¨M ,
¤w§R°£¤£¥Î³o­Ó¨Ò¤l¤F ...

TOP

§Ú¤]¬O®É±`COPY¨ÓCOPY¥hªº
³Ì«á¤]¬O§ä¤£¨ì°ÝÃD©Ò¦b

TOP

        ÀR«ä¦Û¦b : ¤@¥y·Å·xªº¸Ü¡A´N¹³©¹§O¤H¨­¤WÅx­»¤ô¡A¦Û¤v·|ªg¨ì¨â¤Tºw¡C
ªð¦^¦Cªí ¤W¤@¥DÃD