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

[µo°Ý] ¦p¦ó¥Îvbaª¾¹D¿ï¨ú°Ï°ì§@¥ÎªºÀx¦s®æ&Äæ&¦Cªº­ºÄæ¦C¤Î§ÀÄæ¦C¦ì¸m

Set fa = [d2:d65536].SpecialCells(xlCellTypeVisible)(1)
Set fb = [D65536].End(xlUp)
MsgBox fa.Address(0, 0) & ":" & fb.Address(0, 0)
MsgBox fa.Row & ":" & fb.Row

¤£ª¾¨ú³o¦ì§}¥Øªº¬°¦ó¡H

TOP

        ÀR«ä¦Û¦b : µoµÊ®ð¬Oµu¼ÈªºµoºÆ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD