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

[µo°Ý] ¦bVB¤¤¦p¦ó¨ú±oActivecell¤§Row & column¤§°Ñ¼Æ­È

[µo°Ý] ¦bVB¤¤¦p¦ó¨ú±oActivecell¤§Row & column¤§°Ñ¼Æ­È

½Ð°ÝVB±M®a­Ì,¦p¦ó¦bVB¼Ò²Õ¤U­n¥Î¨ººØ°Ñ¼Æ©Î¨ç¼Æ,¨ú±o·Æ¹««ü©w¤§Àx¦s®æ¦C»PÄ椧­È?

GBKEE,
ÁÂÁ§A!

TOP

¦^´_ 1# ohsw
¦bExceºÙ VBA  (Visual Basic For Application)
Sub Ex()
MsgBox ActiveCell.Row
MsgBox ActiveCell.Column
End Sub

TOP

        ÀR«ä¦Û¦b : ¡i®É¤é²öªÅ¹L¡j¤@­Ó¤H¦b¥@¶¡°µ¤F¦h¤Ö¨Æ¡A´Nµ¥©ó¹Ø©R¦³¦hªø¡C¦]¦¹¥²¶·»P®É¶¡Ävª§¡A¤Á²ö¨Ï®É¤éªÅ¹L¡C
ªð¦^¦Cªí ¤W¤@¥DÃD