ªð¦^¦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Ä椧­È?

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

TOP

GBKEE,
ÁÂÁ§A!

TOP

        ÀR«ä¦Û¦b : ·R¤£¬O­n¨D¹ï¤è¡A¦Ó¬O­n¥Ñ¦Û¨­ªº¥I¥X¡C
ªð¦^¦Cªí ¤W¤@¥DÃD