yamatetsu0111/vba_find.vb

Last active November 22, 2020 06:01

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/yamatetsu0111/d0a2b7cba2f2fc6b6d092eb7bbec9cd9.js"></script>
Save yamatetsu0111/d0a2b7cba2f2fc6b6d092eb7bbec9cd9 to your computer and use it in GitHub Desktop.

Download ZIP

VBAのfindの基本的な使い方

Raw

vba_find.vb

	Sub find()
	Dim Target As Range

	Set Target = Range("B:B").find(what:="りんご")
	Debug.Print (Target.Address)

	End Sub

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