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

[µo°Ý] ·Q½Ð±Ð¦³Ãö´¡¤JÄ檺°ÝÃD

[µo°Ý] ·Q½Ð±Ð¦³Ãö´¡¤JÄ檺°ÝÃD

¦U¦ì¥ý¶i¤j®a¦n¡I¤p§Ì¦³¤@­Ó°ÝÃD·Q½Ð±Ð¡A¤p§Ì´¿¸g¬Ý¹L§O¤H¼gªºexcelÀÉ¡A¤]¬O¦³Ãö­pºâ¦¨ÁZªº³nÅé¡Aµ²ºc¦p¤U
¼ÐÃD¼ÐÃD¼ÐÃD¼ÐÃD¼ÐÃD¼ÐÃD¼ÐÃD¼ÐÃD¼ÐÃD¼ÐÃD¼ÐÃD¼ÐÃD¼ÐÃD¼ÐÃD¼ÐÃD¼ÐÃD¼ÐÃD¼ÐÃD¼ÐÃD¼ÐÃD¼ÐÃD¼ÐÃD¼ÐÃD¼ÐÃD
ABCDEFG H
ABCDEFG H
ABCDEFG H
ABCDEFG H
ABCDEFG H
ABCDEFG H
ABCDEFG H
ABCDEFG H
¨ä¤¤A¨ìG³£¬O¤À¼Æ¦ÓH¬O¥­§¡­È¡A¦Ó¼ÐÃD¤W¦³­Ó¥¨¶°«ö¶s¡A¥i¥H¦bG«á­±¦A·s¼W¤@¾ãÄæ¡A¥i¥H¤@ª½·s¼W¡A¤p§Ìªº°ÝÃD¨Ó¤F¡C­ì¥»§Ú¤]¬O·ÓµÛ¼Ò¥é¡A¦ý¬O¤@¥¹·s¼W¡AHÄ檺­ì¨Ó½s¸¹´N·|§ïÅÜ¡]¨Ò¦pA8Åܦ¨A9¡^¨º»ò§Úªº¾ã­Ó»yªk´N·|¶]±¼¡A½Ð°Ý¦³¦ó³]©w¥i¥H©T©w¡A©Î¬O¦³¨ä¥LªºÅܳq¤èªk¡HÁÂÁ¡C

¦^´_ 1# skyutm


    ¤£À´
­ì¨Ó½s¸¹´N·|§ïÅÜ¡]¨Ò¦pA8Åܦ¨A9¡^¨º»ò§Úªº¾ã­Ó»yªk´N·|¶]±¼
¬O¬Æ»ò·N«ä?
°µ­ÓÀɮפW¶Ç¬Ý¬Ý§a!
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# Hsieh
¤£¦n·N«ä¡I§Ú¨S»¡²M·¡¡A´N¬O­ì¥»§Úªº¥­§¡¬O¦bG³o¤@Äæ¡A«ö¤U·s¼W¤@Äæ«á¡A§Úªº¥­§¡Äæ¦ì´N·|Åܦ¨H¡A¥i¬O§Ú¨ä¥Lªº¤u§@ªíªº»yªk¬O¹w³]G³o¤@Äæ¡A¨ì®É­Ô»yªk·|Åã¥Ü¿ù»~¡A§ä¤£¨ì¥­§¡¦¨ÁZ¡I Book1.rar (12.63 KB)

TOP

¦^´_ 3# skyutm
¨º­n¬Ý§A¨ä¥L¤u§@ªíªº¤½¦¡¬O«ç»ò¼gªº?
©Î¬O§A­n§ä¥­§¡Äæ¦ì¤£ª¾¦p¦óÅÜ°Ê?
³o¥i§Q¥Î©w¸q¦WºÙ
¨Ò¦p:§A±NSheet1!$G$1³]©w¦WºÙ¬°¥­§¡
¨º»ò¤£½×¦¡VBA©Î¤½¦¡³£¥i¨Ï¥Î¦¹¦WºÙ¨Ó©w¦ì

Book1.zip (14.07 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 4# Hsieh
ª©¤j¡I¤£¦n·N«ä¦A¥´ÂZ¤@¤U¡AÃö©óÀɮ׸̭±ªº»yªk¡G
Sub Macro1()
    Range("D2").Select
    Selection.EntireColumn.Insert , CopyOrigin:=xlFormatFromLeftOrAbove
    MsgBox "¥­§¡­È¦b" & [¥­§¡].Address
End Sub
­«ÂI¬O¤£¬O¦b³o¸Ì¡G[¥­§¡].Address¡A³o¸Ì´N¥i¥HÂê©w¦WºÙ¬O¥­§¡ªºÄæ¦ì¡A¦ý¬O§Ú°µ¤F¤@­Ó¹êÅç¡A§Ú¦b¨ä¥LÄæ¦ì¤]¿é¤J¥­§¡¡A¥i¬Oµ²ªG¤]¬O­ì¨Ó¥¿½Tªº¨º¤@Äæ¡A¦A¦¸½Ð±Ð³o»yªkªº¥Îªk¡HÁÂÁ¡C

TOP

¦^´_ 5# skyutm
¥­§¡¨º­Ó¦ì¸mªº¤½¦¡¦b´¡¤JÄæ¦ì«á·|¦Û°Ê½Õ¾ãÂX¤j°Ñ·Ó½d³ò
©Ò¥H¡A¥u­n©w¦ì¤F³o­ÓÀx¦s®æ¡A¤£ºÞ³o¤¤¶¡´¡¤J´XÄæ¡A³£·|¦Û°Ê±N´¡¤JªºÀx¦s®æºâ¤J¥­§¡
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 6# Hsieh
ª©¤j¡I¤£¦n·N«ä¡A§Ú¨S»¡²M·¡¡A§Úªº·N«ä¬O¦pªG¦³«Ü¦hÄæ¦ìªº¦WºÙ³£¥s°µ¡u¥­§¡¡v©O¡A¨º¹q¸£«çª¾­n§ä­þ¤@­Ó¡H

TOP

¦^´_ 7# skyutm
"©w¸q¦WºÙ"½Ð¨ì
¿ï³æ>¤½¦¡>¦WºÙºÞ²z­û¬d¬Ý

¸ò§AÀx¦s®æÄæ¦ì¦WºÙ¨S¦³Ãö«Y

TOP

¦^´_ 8# stillfish00
·PÁ¤j¤j¸Ñ´b¡I¤p§Ì¨ü¥Î¤F¡C

TOP

¦^´_ 6# Hsieh
ª©¤j¡I¤£¦n·N«ä¡A¤S¨Ó¥´ÂZ¡A¤p§Ì¥¼¯àÁ|¤@¤Ï¤T¡A¦³¨ÇºF·\¡A°ÝÃD¦p¤U¡G
¦Û±q¤W¦¸¨ü±Ð¤§«á¡A¤p§Ì§ï¼g»yªk¦p¤U¡A
Sub Macro1()
    Range("D2").Select
    Selection.EntireColumn.Insert , CopyOrigin:=xlFormatFromLeftOrAbove
    Dim a, b As String
     b = [¥­§¡].Address
     a = Mid(b, 2, 1)
    MsgBox a
End Sub
«á­±³o¤@¬q¬O­nª¾¹D¡]¥­§¡¡^Äæ¦ìªº¦ì¸m¶}ÀY­^»yºÙ¸¹¡A¨Ò¦p¡]d1¡^ªºd¡A¦]¬°¦b¨ä¥L¤u§@ªí¦³°j°é­n¼g¡A¨Ò¦p
With Sheets("´Á¤¤µû¶q")
    j = Sheets("°ò¥»³]©w").Range("j3").Value + 5
    For i = 6 To j
    Sheets("´Á¤¤¦¨ÁZ").Range("c" & i).Value = (.Range("c" & i - 3) * ch1 + .Range("h" & i - 3) * ch2 + .Range("i" & i - 3) * ch3 + .Range("j" & i - 3) * ch4) / 100
    Sheets("´Á¤¤¦¨ÁZ").Range("d" & i).Value = (.Range("d" & i - 3) * en1 + .Range("k" & i - 3) * en2 + .Range("l" & i - 3) * en3 + .Range("m" & i - 3) * en4) / 100
    Sheets("´Á¤¤¦¨ÁZ").Range("e" & i).Value = (.Range("e" & i - 3) * ma1 + .Range("n" & i - 3) * ma2 + .Range("o" & i - 3) * ma3 + .Range("p" & i - 3) * ma4) / 100
    Sheets("´Á¤¤¦¨ÁZ").Range("f" & i).Value = (.Range("f" & i - 3) * na1 + .Range("q" & i - 3) * na2 + .Range("r" & i - 3) * na3 + .Range("s" & i - 3) * na4) / 100
    Sheets("´Á¤¤¦¨ÁZ").Range("g" & i).Value = (.Range("g" & i - 3) * so1 + .Range("t" & i - 3) * so2 + .Range("u" & i - 3) * so3 + .Range("v" & i - 3) * so4) / 100
    Next i
    End With
¦ý¬O¡A°ÝÃD¨Ó¤F¡A¦pªGÄæ¦ì¤@ª½·s¼W¡A¨ì¤FZ¤§«á¡A´N·|±qAA¶}©l½s¸¹¡A¨º°j°é´N·|¥X°ÝÃD¡AÀµ½Ð¸Ñ´b¡A¦A¦¸·PÁ¡I

TOP

        ÀR«ä¦Û¦b : ¤H­n¦Û·R¡A¤~¯à·R´¶¤Ñ¤Uªº¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD