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

[µo°Ý] ¦p¦ó±NÀx¦s®æ¤º®e´¡¤Jµù¸Ñ

[µo°Ý] ¦p¦ó±NÀx¦s®æ¤º®e´¡¤Jµù¸Ñ

¥»©«³Ì«á¥Ñ shuasa ©ó 2017-1-16 21:33 ½s¿è

¦p¦ó±NH1ªº¤º®e´¡¤J¨ìH3:H13ªºµù¸Ñ,
½Ð¦U¦ì¤j¤j«ü±Ð,ÁÂÁÂ!

ªÑ²¼¥æ³Î±b¤áºÞ²z.rar (92.71 KB)
shuasa

Sub AA()
For x = 3 To 13
  With Sheet1.Cells(x, 8).Comment
   .Shape.TextFrame.Characters.Text = Mid(Sheet1.Cells(x, 8).FormulaLocal, 2) & "=" & [H1].Value
  End With
Next
End Sub
ù

TOP

¦^´_ 2# rouber590324


    ·PÁÂÁ¤j¤j«ü±Ð,°ÝÃD¸Ñ¨M¤F
shuasa

TOP

        ÀR«ä¦Û¦b : ¡i¬°µ½Ävª§¡j¤H¥Í­n¬°µ½Ävª§¡A¤À¬í¥²ª§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD