harsha547/VBA Tricks _ Find

Created June 8, 2017 16:13

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

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

Download ZIP

Raw

VBA Tricks _ Find

	Sub findd()

	Dim rg As Range

	Set rg = Range("E:E").Find("Bulgaria")

	Debug.print rg.offset(0,1)

	End Sub

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