Imagine I have a variable that has a lot of text in it, let's call it strLargeString, and in it, there's string like {1}, {2}, {3}, etc.. what would be faster?

VB Code:
  1. For x = 1 to 100
  2.    strLargeString = Replace(strLargeString, "{" & x & "}", "replaced")
  3. Next

Or

Loop through the string using InStr to find the first {, then the next } and replace it after and move to the next ?

The first option, I let VB internal function to do the work, which could be faster, but is always has to start from the beginning. The second option, I keep moving the cursor to towards the end...

What are your thoughs on this ?