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

½Ð±Ð¡G¨ì³Ì«á¤@¦Cªº¤èªk...

Sub zz()
a = Range("a1:a" & Cells(Rows.Count, 1).End(3).Row).Value
For i = UBound(a) To 1 Step -1
    If Len(a(i, 1)) Then Exit For
Next
Cells(i, 1).Select
End Sub

TOP

        ÀR«ä¦Û¦b : ¨C¤ÑµL©Ò¨Æ¨Æ¡A¬O¤H¥Íªº®ø¶OªÌ¡A¿n·¥¡B¦³¥Î¤~¬O¤H¥Íªº³Ð³yªÌ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD