find

  • Thread starter Thread starter ranswert
  • Start date Start date
R

ranswert

I am using "find" to find a string in a range of cells. How do I keep
searching in the range for more occurrances of that string I am searching
for? I think there is a "find next" , but I am not sure how to use it with
"find".

Thanks
 
Look in the vba help index for FINDNEXT. Essentially it is a find loop.
There is a good example.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find the correct sheet then find a value on that sheet 8
Set range, perform operation, set new range, repeat 1
Interactive Find and Copy 3
.FindNext problem 3
Code does not error but no copy either 4
A For Each in Range... with a .Find(what:="TJ", ... in it problem 15
VBA set thick borders around non empty cells in range 0
Find "386", but not "386c" 2

Back
Top