ªð¦^¦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 : Ä@­n¤j¡B§Ó­n°í¡B®ð­n¬X¡B¤ß­n²Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD