0

I'm trying to create a small Excel script lab example that finds all matches of a search string within a selected range. However, unlike VBA, the range.find() method does not appear to have a way to find the next match?

Eugene Astafiev
  • 47,483
  • 3
  • 24
  • 45
jkpieterse
  • 2,727
  • 1
  • 9
  • 18

1 Answers1

0

A new range instance is returned from the call to the find method. Going to the next cell you could start anew with a new range.

Eugene Astafiev
  • 47,483
  • 3
  • 24
  • 45
  • Yes I know. So what if I want to search within a range? So suppose I want to limit my search to B2:D10 and find all entries in that range? – jkpieterse Apr 25 '22 at 14:01