siguremon/file0.txt

Created December 11, 2013 02:09

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/siguremon/7904067.js"></script>
Save siguremon/7904067 to your computer and use it in GitHub Desktop.

Download ZIP

データがある範囲を抽出する ref: http://qiita.com/siguremon/items/4fbdb2585b74fa9e8701

Raw

	Dim lastRow As Long
	Dim varData As Variant

	lastRow = Range("A" & Rows.Count).End(xlUp).Row
	varData = Range("A1:A" & lastRow).value

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment