¡@¼ÊºÙ: ÀH·ÄÆ¿ºªº¦Ð¤ò ¡@ÀY»Î: [±s¥Î]¼ç¤ô¸¥
°ª¤¤¥Í
- ©«¤l
- 852
- ¥DÃD
- 79
- ºëµØ
- 0
- ¿n¤À
- 918
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows 7 , XP
- ³nÅ骩¥»
- Office 2007, Office 2003,Office 2010,YoZo Office
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¦t©z
- µù¥U®É¶¡
- 2011-4-8
- ³Ì«áµn¿ý
- 2024-2-21
|
¥»©«³Ì«á¥Ñ mark15jill ©ó 2011-5-23 15:15 ½s¿è
¦^´_ 1# cw3076
Sub Macro1()
'
' Macro1 Macro
'
' GBKEE ¤j¤j´£¨Ñªº
'
Rows("2:2").Value = Rows("1:1").Value 'rows("2:2") = ¤U¤@¦C rows("1:1")=¥Ø«e¦C
End Sub
or
sub xx
Rows("2").Select
Selection.FormulaR1C1 = "=R[-1]C"
Rows("3").Select
Selection.FormulaR1C1 = "=R[-1]C"
Rows("4").Select
Selection.FormulaR1C1 = "=R[-1]C"
Rows("5").Select
Selection.FormulaR1C1 = "=R[-1]C"
end sub
ps «Ü·Qª½±µ¥Î¯x°}¤U¥h±a= = ¦ý¬O µ{«×§C ¸ÕÅ祢±Ñ=£¾= |
|