ªð¦^¦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 : ¬°¤H³B¥@­n¤p¤ß²Ó¤ß¡A¦ý¤£­n¡u¤p¤ß²´¡v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD