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

¨C¤@­¶¤p­p

¨C¤@­¶¤p­p

¤£ª¾¹D·|¤£·|¤Ó²L
¦]¬°§Ú¨C­¶ªºÄæ¦ì¤£©T©w
¦ý§Ú·Q¦b¨C¤@­¶ªº³Ì«á¤@Äæ°µ¤@­Ó¤p­p
½Ð°Ý­n«ç¼Ë¿ì¨ì³o­Ó¤u§@

¦^´_ 1# modelcrazyer

µ¹§A­Ó¤èªk
'Åã¥Ü¥Ø«e­¶­±ªº¨Ï¥Î¦C¼Æ
MsgBox ActiveSheet.Range("A1").CurrentRegion.Rows.Count
'Åã¥Ü¥Ø«e­¶­±ªº¨Ï¥ÎÄæ¼Æ
MsgBox ActiveSheet.Range("A1").CurrentRegion.Columns.Count

«Øij:
¦pªGª½±µ·j´M"Á`©M",¦A©¹¥k²¾°Ê¤@®æ§@­pºâ,¤]¥i¥H¹F¨ì±zªº»Ý¨D.

  ¦h°µ¦h·Q¦h¾Ç²ß¡A¤Ö¬Ý¤Ö¿ù¤Ö°g³~

  ¦h°µ=¦h¦h½m²ß¡A¦h¦h½s¼g¡C
  ¦h·Q=·Q·Q¬°¤°»ò¤H®aµ{¦¡­n¨º¼Ë¼g¡A¦pªG´«¦¨¦Û¤v¡A¤S·|«ç¼g¡C
  ¦h¾Ç²ß=¾Ç²ß¤H®aªºµo°Ý¨Ã¸Ñµª¡A¾Ç²ß¤H®aªº¼gªk

  ¤Ö¬Ý=¥u¬Ý¤£°µ¤]ªPµM

TOP

¦^´_ 1# modelcrazyer


    °ò¥»¾Þ§@:
¸ê®Æ/¤p­p
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

ÁÂÁ¨â¦ìªº¦^µª
§Ú·Q¥i¯à¨SÁ¿²M·¡,§Ú¬O¥´ºâ¦C¦L®É
¦Û°Ê¦b¦C¦L®É±N¨C­¶ªº³Ì«á¤@Äæ¥[¤J¤p­p

TOP

        ÀR«ä¦Û¦b : ¸Ü¦h¤£¦p¸Ü¤Ö¡A¸Ü¤Ö¤£¦p¸Ü¦n¡C
ªð¦^¦Cªí ¤W¤@¥DÃD