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

[µo°Ý] ¨â¦C¤§­È¬Û¦P

[µo°Ý] ¨â¦C¤§­È¬Û¦P

½Ð±Ð¤j¤j,
  §Ú¦³¤G¦Cªº¼Æ­È, §Ú·QÅý¤U¦C¤§­Èµ¥©ó¤W¤@¦C,
   ½Ð°ÝVBAµ{¦¡¦p¦ó¼g?

¦^´_ 1# cw3076
B=A.Value

TOP

¥»©«³Ì«á¥Ñ 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 ¸ÕÅ祢±Ñ=£¾=

TOP

        ÀR«ä¦Û¦b : µÊ®ð¼L¤Ú¤£¦n¡A¤ß¦a¦A¦n¤]¤£¯àºâ¬O¦n¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD