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

°Ñ·ÓYÄæ§ä¨ìXÄæªÅ¥Õªº¦ì¸m

¦^´_ 3# myleoyes
  1. Sub Ex()
  2.      Dim R%, C%
  3.      With Sheet1
  4.         C = Month(Date) * 3
  5.         R = IIf(.Cells(Rows.Count, C).End(3).Row > .Cells(Rows.Count, C + 1).End(3).Row, .Cells(Rows.Count, C).End(3).Row, .Cells(Rows.Count, C + 1).End(3).Row)
  6.         .Cells(R + 1, C).Select
  7.       End With
  8. End Sub
½Æ»s¥N½X

TOP

        ÀR«ä¦Û¦b : ¤Ó¶§¥ú¤j¡B¤÷¥À®¦¤j¡B§g¤l¶q¤j¡A¤p¤H®ð¤j¡C
ªð¦^¦Cªí ¤W¤@¥DÃD