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

[µo°Ý] ·Æ¹«°ÝÃD½Ð±Ð

[µo°Ý] ·Æ¹«°ÝÃD½Ð±Ð

DEAR ALL ¤j¤j
1.½Ð°Ý·í·Æ¹«²¾¦Ü¥ô¤@Àx¦s®æ.©óA1¨q¥X¨äÄæ A2¨q¥X¨ä¦C¤§µ{¦¡¦p¦ó®Ñ¼g.
    1.1 ¨Ò - ·Æ¹«²¾¦ÜRANGE("B100") ®É©ó   A1¨q¥X 2(Äæ2)  A2¨q¥X 100(¦C100)
             ·Æ¹«²¾¦ÜRANGE("D500") ®É©ó   A1¨q¥X 4(Äæ4)  A2¨q¥X 500(¦C500)......
2.·Ð¤£§[½ç±Ð   THANKS
ù

·Æ¹«°ÝÃD½Ð±Ð

[µo°Ý] ·Æ¹«°ÝÃD½Ð±Ð
DEAR ALL ¤j¤j
1.½Ð°Ý·í·Æ¹«´å¼Ð²¾¦Ü¥ô¤@Àx¦s®æ.©óA1¨q¥X¨äÄæ A2¨q¥X¨ä¦C¤§µ{¦¡¦p¦ó®Ñ¼g.
    1.1 ¨Ò - ·Æ¹«²¾¦ÜRANGE("B100") ®É©ó   A1¨q¥X 2(Äæ2)  A2¨q¥X 100(¦C100)
               ·Æ¹«²¾¦ÜRANGE("D500") ®É©ó   A1¨q¥X 4(Äæ4)  A2¨q¥X 500(¦C500)......
2.·Ð¤£§[½ç±Ð   THANKS
ù

TOP

­n¥Î·Æ¹«ÂI¤@¤U

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
MsgBox Target.Row
End Sub

TOP

­n¥Î·Æ¹«ÂI¤@¤U
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
[A1] = Target.Column
[A2] = Target.Row
End Sub

TOP

DEAR  SIR
  TEST OK §¹¥þ²Å¦X»Ý¨D. THANKS*1000
ù

TOP

¦^´_ 1# rouber590324


¦³¤H¦^À³§A¤F¡A½Ð¤£­n­«½Æµo¤å¡A

½×¾Â¸ê·½¦³­­¡A½Ð¤£­n¶d­t§O¤H¹ï§Aªº¤@¤ù¥Î¤ß¡A¤£³Ó·P¿E¡ã

·Æ¹«°ÝÃD½Ð±Ð
1

µû¤À¤H¼Æ

    • GBKEE: µ¹§A«ö¤@¤UÆgª÷¿ú + 2
§Ú«Ü²Â,©Ò¥H§Ú«Ü¥Î¤ß
¡@§Ú¾ÇÃÀ¤£ºë,¦ý§Ú´÷¨Dª¾ÃÑ

TOP

dear  all
  sorry ¤p§Ì¬O¦]¬°°Ýµ{¦¡°ÝÃD¶K¨ì¤@¯ë°Ï.¤~·|­«ÂЩóµ{¦¡°Ïµo¨¥.
  ·PÁ«ü¾É.¤U¦¸·|ª`·N¦a.  thanks*10000
1

µû¤À¤H¼Æ

    • GBKEE: ¤£ª¾ªÌµL¸oª÷¿ú + 1
ù

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦¨´N¤@¤Á¡j®É¶¡¥i¥H³y´N¤H®æ¡A¥i¥H¦¨´N¨Æ·~¡A¤]¥i¥HÀx¿n¥\¼w¡C
ªð¦^¦Cªí ¤W¤@¥DÃD