Free for PREMIUM members
Dim rng As Range
Dim n As Integer
n = Application.InputBox("Which occurrence of 101th cell you want to select? (e.g. 1,2,3...)", Type:=1)
Set rng = Range("A:F")
If n <> 0 Then rng.Cells(101 * n).Select
Open in new window
We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Author Closing Comment
New feature! Upgrade and increase expert visibility of your issues with Priority Questions.
If you are experiencing a similar issue, please ask a related question
Join the community of 500,000 technology professionals and ask your questions.
Join & Ask a Question
Join our community for more solutions or to ask questions.
For immediate help use Live now!