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

[µo°Ý] ¨Ï¥ÎVBA¦Û­q½d³ò¸ê®ÆÅçÃÒ¥¢±Ñ

¦^´_ 2# PKKO


    §ï³o¼Ë¸Õ¸Õ
  1. Dim myrange As Range
  2. With Sheets("Âà´«ªí")
  3.      Set myrange = .Range("s2:s" & .Range("s65536").End(xlUp).Row) '¸ê®ÆÅçÃÒ¥Î
  4. End With
½Æ»s¥N½X

TOP

        ÀR«ä¦Û¦b : §g¤l¬°¥Ø¼Ð¡A¤p¤H¬°¥Øªº¡C
ªð¦^¦Cªí ¤W¤@¥DÃD