M
muyBN
In a 4GuysFromRolla article, it was explained that the use of regular
expressions can be used to search for different patterns. I would like to
know if they can as well be used to evaluate text in a selection or range,
not just for searching text. For example, I would like to know if there is a
way to replace one of the asterisks in the code below so that it reads "any
number" with a regular expression instead of "any combination of characters"
with the wild-card asterisk.
With Application.FileSearch
..FileName = "*listings*.csv"
expressions can be used to search for different patterns. I would like to
know if they can as well be used to evaluate text in a selection or range,
not just for searching text. For example, I would like to know if there is a
way to replace one of the asterisks in the code below so that it reads "any
number" with a regular expression instead of "any combination of characters"
with the wild-card asterisk.
With Application.FileSearch
..FileName = "*listings*.csv"