- ©«¤l
- 84
- ¥DÃD
- 13
- ºëµØ
- 0
- ¿n¤À
- 104
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- SP3
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-8-10
- ³Ì«áµn¿ý
- 2018-4-21
|
¦^´_ 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¬Onª¾¹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 |
|